Home Page link  

Sharing an excel spreadsheet

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Sharing an excel spreadsheet stillbreathing 08-04-2008
Posted by stillbreathing on August 4, 2008, 12:16 pm
Please log in for more thread options
I am trying to make an Excel spreadsheet so that people from different
departments can put information into it and then we can save it as one
spreadsheet -- my hope is that from this spreadsheet we could see at any
particular time just where this particular item is in our manufacturing
process or when it left.

I have put the spreadsheet in a shared folder and mapped a drive to the
spreadsheeet. I am using 2007 and the other people are using 2003. I have
made saved the file so that it is in compatibility mode. They can put the
information in, but they can not save the information to make the change. I
really don't want to get into merging spreadsheets and to have someone in one
department commit to doing this (especially when we are busy) pretty much
defeats the purpose of the idea.

Any ideas of what I can do?

Posted by Todd on August 5, 2008, 2:28 pm
Please log in for more thread options
On Aug 4, 9:16 am, stillbreathing
> I am trying to make an Excel spreadsheet so that people from different
> departments can put information into it and then we can save it as one
> spreadsheet -- my hope is that from this spreadsheet we could see at any
> particular time just where this particular item is in our manufacturing
> process or when it left.
>
> I have put the spreadsheet in a shared folder and mapped a drive to the
> spreadsheeet. I am using 2007 and the other people are using 2003. I have
> made saved the file so that it is in compatibility mode. They can put the
> information in, but they can not save the information to make the change. I
> really don't want to get into merging spreadsheets and to have someone in one
> department commit to doing this (especially when we are busy) pretty much
> defeats the purpose of the idea.
>
> Any ideas of what I can do?

Why not use one of Google's spreadsheets...they are available online
for anyone to access for read/write.

http://docs.google.com

Hope this helps...

Regards,
Todd

Posted by stillbreathing on August 5, 2008, 5:10 pm
Please log in for more thread options
Todd,

Thanks for the advice, I will run it by the boss. I know he is a little
leary of posting stuff on the internet. This looks secure, but there is a
lot of sensitive information on it.

"Todd" wrote:

> On Aug 4, 9:16 am, stillbreathing
> > I am trying to make an Excel spreadsheet so that people from different
> > departments can put information into it and then we can save it as one
> > spreadsheet -- my hope is that from this spreadsheet we could see at any
> > particular time just where this particular item is in our manufacturing
> > process or when it left.
> >
> > I have put the spreadsheet in a shared folder and mapped a drive to the
> > spreadsheeet. I am using 2007 and the other people are using 2003. I have
> > made saved the file so that it is in compatibility mode. They can put the
> > information in, but they can not save the information to make the change. I
> > really don't want to get into merging spreadsheets and to have someone in one
> > department commit to doing this (especially when we are busy) pretty much
> > defeats the purpose of the idea.
> >
> > Any ideas of what I can do?
>
> Why not use one of Google's spreadsheets...they are available online
> for anyone to access for read/write.
>
> http://docs.google.com
>
> Hope this helps...
>
> Regards,
> Todd
>

Posted by jennydat on August 6, 2008, 11:27 am
Please log in for more thread options


Hi stillbreathing

Is the file marked as 'read only'?
Do the various users have access to amend files on the domain, or just to
read them?
--
Jenny


"stillbreathing" wrote:

> Todd,
>
> Thanks for the advice, I will run it by the boss. I know he is a little
> leary of posting stuff on the internet. This looks secure, but there is a
> lot of sensitive information on it.
>
> "Todd" wrote:
>
> > On Aug 4, 9:16 am, stillbreathing
> > > I am trying to make an Excel spreadsheet so that people from different
> > > departments can put information into it and then we can save it as one
> > > spreadsheet -- my hope is that from this spreadsheet we could see at any
> > > particular time just where this particular item is in our manufacturing
> > > process or when it left.
> > >
> > > I have put the spreadsheet in a shared folder and mapped a drive to the
> > > spreadsheeet. I am using 2007 and the other people are using 2003. I have
> > > made saved the file so that it is in compatibility mode. They can put the
> > > information in, but they can not save the information to make the change.
I
> > > really don't want to get into merging spreadsheets and to have someone in
one
> > > department commit to doing this (especially when we are busy) pretty much
> > > defeats the purpose of the idea.
> > >
> > > Any ideas of what I can do?
> >
> > Why not use one of Google's spreadsheets...they are available online
> > for anyone to access for read/write.
> >
> > http://docs.google.com
> >
> > Hope this helps...
> >
> > Regards,
> > Todd
> >

Similar ThreadsPosted
Importing from an EXCEL spreadsheet June 21, 2006, 11:15 am
Two "Stores" Sharing Inventory January 25, 2007, 9:04 am
OPOS Printer not sharing October 12, 2007, 4:34 am
Sharing Office Manager for 2 sites June 30, 2008, 1:25 pm
RMS MS Access Link - Edit tables in spreadsheet view January 26, 2006, 10:27 am
Import excel into RMS January 6, 2006, 11:43 am
Launch Excel from POS September 12, 2006, 6:25 pm
Importing csv or excel into RMS October 24, 2006, 4:54 pm
Export to Excel May 8, 2007, 11:05 pm
Still having importing difficulties. (from excel to RMS) April 15, 2006, 7:22 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap