Forum Discussion
Hardcore users only - help needed to clean up a Workbook
I attach a file that drives me mad. I just reported the same to Microsoft. The file is a totally pared back production file. It is substantially empty - I deleted practically all. (The single Wor...
This behavior could be related to hidden or "phantom" external links, but I'm not sure, as several pieces of information are not conclusive to me. These are notoriously tricky, especially with large, older workbooks that may have accumulated references or objects over time. In the pasted file, you will find your macro with a small change "For i = 1 To n-Loop" and a macro with "PhantomExternalLinks".
Maybe that helps.
If not, please include more detailed information, such as Excel version, operating system, storage medium, etc.