Outlining Is Not Saved in Excel Workspace PSS ID Number: Q71091 Article last modified on 08-23-1993 PSS database name: W_eXceL
3.00
WINDOWS
Summary:
Outlining cannot be saved if the worksheet is saved as part of a workspace, and the Show Outline Symbols button on the tool bar is not depressed to display the outline symbols prior to closing the workspace.
More Information:
Steps to Reproduce Problem
- Open two worksheets.
- Create an outline on one of the worksheets. Click the Show Outline Symbols button on the tool bar to display the outline symbols.
- From the File menu, choose Save Workspace.
- Choose OK for all following options.
- Click the Show Outline Symbols button on the tool bar to hide the outline symbols.
- While holding down the SHIFT key, select the File menu and choose Close All. Choose OK for all following options.
- Open the workspace.
- Activate the sheet that contains the outline and depress the Show Outline Symbols button.
- The following message results: “Cannot show outline symbols. No outline exists on current worksheet. Create one?” Choose OK. A new message results: “Modify existing one?” Choose OK. The previous outlining will be replaced with the modified outlining.
Workarounds
- Save the workspace again after making the change in Step 5 above.
- Choose not to save changes to the worksheet when you are prompted to do so in Step 6.
Reference(s):
“Microsoft Excel User’s Guide.” Version 3.00, pages 233-234.
Note: This problem does not occur in later versions of Microsoft Excel for Windows.
Additional reference words: noupd
Copyright Microsoft Corporation 1993.