Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Cannot save a shared workbook after inserting a ro (97 sr2)

    A shared workbook is available to all users.
    Track changes can be on or off.
    The user inserts a row on one worksheet
    When the workbook is saved the Excel application shuts down and sends message to Microsoft.

    In the Error Report Contents the Exception portion of the message is:
    Code: 0x0000005 Flags: 0x00000000
    Records: 0x0000000000000000 Address: 0x00000000300010f2

    Anyone else had this problem and is there a solution?

    Cheers
    Alan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cannot save a shared workbook after inserting a ro (97 sr2)

    I don't know a solution, but I strongly recommend NOT sharing workbooks. It is a recipe for corruption.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Cannot save a shared workbook after inserting a ro (97 sr2)

    Yep, couldn't agree more, sharing is an absolute pain but unfortunately the alternatives are access/asp which is limited installation in the client.

    I have a short term solution until the exact reason for the error is traced and eliminated:

    open shared workbook
    open a new workbook
    copy all of the data from each of the worksheets from the shared to the new workbook
    close the shared workbook.
    Save the new workbook
    Share the new workbook.

    New workbook allows inserting rows and saving without any errors or shut downs.

    When I tried dragging and dropping the complete worksheets from the shared workbook to a new workbook, the corruption errors still occurred in the new workbook, - so must have been something with the formatting of empty cells past the end of the tables?

    Cheers anyway.

    Alan

Posting Permissions

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