Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    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.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    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.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •