Microsoft KB Archive/25230

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 19:19, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q25230 to Microsoft KB Archive/25230 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Removing Depending Worksheet Names from Xternal List PSS ID Number: Q25230 Article last modified on 07-21-1988 PSS database name: D_MPlan

3.00 3.01 3.02 3.04


Question: I have a supporting worksheet that has been linked to several other worksheets, all of which have been deleted. When I do an Xternal List, these depending worksheets are still listed. Is there a way to remove them from this list?

Response: The following steps will remove the depending worksheet names from the list displayed in the Xternal List command:

  1. Save the supporting worksheet as a SYLK file by selecting Transfer Options and choosing Symbolic as the mode.
  2. Save the file using the Transfer Save command.
  3. Transfer Clear All (or you could Quit the program and reload it).
  4. Load the file using the Transfer Load command.
  5. Set the mode back to Normal in the Transfer Options menu.
  6. Save the file again, using the Transfer Save command.

Copyright Microsoft Corporation 1988.