The information in this article applies to:
SUMMARYBecause some macros and add-ins (such as SOLVER.XLA), create hidden names on a sheet, links may exist even after you attempt to remove all known references (including objects and formulas). In this situation, when you open a worksheet containing the hidden links, you may receive the following error message:
WORKAROUNDSTo work around this situation, do either of the following:Workaround 1
Workaround 2Use the following macro to find and delete all hidden names in a sheet:
REFERENCES
"Online Help," version 5.0 Additional query words: 3.0 4.0 4.00a 5.0 link
Keywords : |
Last Reviewed: April 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |