Dear All,
I've created a file, loaded with macros, userforms and so on
The file opening becomes gradually slower over the time (usually takes a few weeks), until it becomes impossible to open it.
When this happens, I found a remedy:
1, open it with Excel Online
2, edit it with Excel Online
3, Excel Online removes some content
4, Save as...
5, and I can use my file again with regular Excel for a couple of weeks
I did a file comparison in Excel between these two files, and the only difference Excel gave is:
I have no idea, what's this, and how to fix this
Can anyone explain the root cause and propose the solution?
Thanks Team!
I've created a file, loaded with macros, userforms and so on
The file opening becomes gradually slower over the time (usually takes a few weeks), until it becomes impossible to open it.
When this happens, I found a remedy:
1, open it with Excel Online
2, edit it with Excel Online
3, Excel Online removes some content
4, Save as...
5, and I can use my file again with regular Excel for a couple of weeks
I did a file comparison in Excel between these two files, and the only difference Excel gave is:
- UserForm1: Module Declaration Changed
- OLD: Attribute VB_Base = "0{76478AD2-7F72-4223-BE23-882B06899A98}{3B14D9D4-A10B-4B80-BBCA-B82F5A630CE4}"
- NEW: Attribute VB_Base = "0{0F48BDE0-1EC3-4161-AA60-DB84369C7C06}{A09450F7-0B36-40AE-9ACC-95ACCDE79202}"
I have no idea, what's this, and how to fix this
Can anyone explain the root cause and propose the solution?Thanks Team!
