DutchKevin
Board Regular
- Joined
- Apr 13, 2011
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
Hi
I had a macro which was looking at another file for it's creation date, and pasted in my sheet a vlookup formula to that other file. range().formula = "=vlookup etc. It worked.
But the macro has been removed again from my module, I solved it differently now
But now when loading excel from scratch the xlam loading takes a whole minute, and in the bottom status bar i see it tries to reference that other file for some reason.
I cannot find any place where i can see why it still does this.
During my checks i did see that the xlam file itself is now 29 MB big, but if that is new, or has been so for longer i cannot tell. I have 20+ modules etc in the xlam file
Any advice on how to hunt the issue down?
I hate to have the export import all the modules to a new xlam
Thanks for any support!
Kevin
I had a macro which was looking at another file for it's creation date, and pasted in my sheet a vlookup formula to that other file. range().formula = "=vlookup etc. It worked.
But the macro has been removed again from my module, I solved it differently now
But now when loading excel from scratch the xlam loading takes a whole minute, and in the bottom status bar i see it tries to reference that other file for some reason.
I cannot find any place where i can see why it still does this.
During my checks i did see that the xlam file itself is now 29 MB big, but if that is new, or has been so for longer i cannot tell. I have 20+ modules etc in the xlam file
Any advice on how to hunt the issue down?
I hate to have the export import all the modules to a new xlam
Thanks for any support!
Kevin