You guys rock!
I reformatted each column as a single selection then copied each worksheet to a new file. I also went into the named ranges and removed the external reference that it plugged in there; effectively I had a brand new, squeaky clean file. Saved it back out and, lo and behold, it...
I have been having trouble with a particular file that works fine for a while then refuses to open.
When I go back to an earlier version of the file, it works fine, I enter some more data for a while then suddenly it flakes out again and I can't open the file without a type 2 error and Excel...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.