Share Excel Worksheet

A

Aurora

I am using Excel 2003
I created our price book in Excel. It was created so that the sales people
can copy information from a product price sheet to a call log. So that we
have a record of which quotes we did not get an order on. What do I have to
do to make the workbook shareable between 4 different sales people? Right
now, if one person is using the price book, and another person tries to open
the price book, they get the message that they can only open it up as a read
only. I would appreciate any help you can give me.

Aurora
 
R

ryguy7272

Tools > Share Workbook > Editing > check the box.
Be forewarned, if multiple users are in the file, there will be stability
issues and thus constant headaches...

You would be MUCH better off using Access for a task such as this. Access
can easily be shared among many users. In fact, Access was designed for this
purpose, Excel was not.

HTH,
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top