XL2000: Illegal Operation Saving Shared Workbook

• Microsoft Excel 2000

SYMPTOMS

When you try to save a workbook that is shared, you may receive the following error message:

This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor.

EXCEL caused an invalid page fault in module EXCEL.EXE at 015f:306107dd.

CAUSE

This problem occurs when all of the following conditions are true:

• You work in a shared workbook.
  
  -and-



• The workbook contains one or more formulas using the CHOOSE function.
  
  -and-



• You make a change to the formula and save the workbook.

WORKAROUND

If you need to make changes to a formula that uses the CHOOSE function and the workbook is shared, you must first unshare the work, make changes to the formula, and then reshare the workbook. When you remove a workbook from shared use, you disconnect all other users from the shared workbook, turn off the change history, and erase the stored change history, so that you can no longer view the history or merge this copy with other copies of the shared workbook.

NOTE: To ensure that others do not lose work in progress, make sure that all other users have been notified so that they can save and close the shared workbook before you remove it from shared use.

To unshare a workbook:

1. On the Tools menu, click Share Workbook, and then click the Editing tab.



2. Make sure that you are the only person listed in the Who has this workbook open now list. If other users are listed, they will lose any unsaved work.



3. Click to clear the Allow changes by more than one user at the same time check box, and click OK.



4. When prompted about the effects on other users, click Yes.



5. Make the necessary changes to the CHOOSE function.



6. Reshare the workbook.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL2000 ipf gpf workgroup crash crashes crashing crashed quit quitting quits fail fails failing failed break

Keywords : kberrmsg kbnetwork kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug