Microsoft KB Archive/231140

= XL2000: Illegal Operation Saving Shared Workbook =

Article ID: 231140

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q231140



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.

If you click Details, you receive an error message similar to the following

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

and Microsoft Excel quits.



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 that this is a problem in the Microsoft products that are 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 kbbug kbnetwork kbpending KB231140

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.