Results 1 to 2 of 2
2008-07-03, 21:20 #1
- Join Date
- Jul 2006
- Thanked 0 Times in 0 Posts
Problem with read only message in excel file (2003)
There are various users trying to access a spreadsheet each individual has to access a worksheet within the file, the problem is that if there are various users trying to access the file at one time which makes it 'read only'. It is possible to make just a worksheet read only and not the file. As the users only need to access there particular worksheet.
2008-07-04, 00:12 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Re: Problem with read only message in excel file (2003)
If they just need "access" without having to modify I think what is happening is perfect. We do this with many files.
But if they need to edit and modify at the same time, some options I see:
You could use a program that works well with multiple editors (something like Access)
You could save each worksheet as a separate workbook and if you summarize data across the workbooks have a different file which has links to the other workbooks so it is will updated upon opening with any changes.