My spreadsheets must be able to allow access from other users through a
Public drive in my company. Problem is when they pull it up it is a READ ONLY
spreadsheet. How do I make it to where the spreadsheet can be edited by
anyone in the company?

You can share the workbook (Tools - Share Workbook) but read up on sharing
workbooks first. There are some retrictions on shared workbooks.

As a complete aside I personally avoid shared workbooks as I find them to be
more trouble than they are worth. I normally deal with concurrent access by
storing all of my data in a database but that may not be practicle or
feasable for you.
--
HTH...

Jim Thomlinson


"HoganD87" wrote:

My spreadsheets must be able to allow access from other users through a
Public drive in my company. Problem is when they pull it up it is a READ ONLY
spreadsheet. How do I make it to where the spreadsheet can be edited by
anyone in the company?

Hi,

Please refer to the following topic in the Microsoft Excel 2003 online help:

1. About shared workbooks
2. Share a workbook

Challa Prabhu

"HoganD87" wrote:

My spreadsheets must be able to allow access from other users through a
Public drive in my company. Problem is when they pull it up it is a READ ONLY
spreadsheet. How do I make it to where the spreadsheet can be edited by
anyone in the company?