I've been building a 40 meg, 40 tab, workbook that contains macros, named
ranges, vlookup, etc. for over a year. Just last week, I started receiving a
message on the latest version of the workbook stating File Error: Data May
Have Been Lost when opening the file. Nothing had changed, except the name
of the file which was renamed for the day's date and a few of the input
cells. I found the error pretty quickly...a formula in a couple of cells was
totally replaced with "#REF". I copied the formulas from adjacent cells and
all looked fine. I renamed the file and went about my business.
Since then, that file is fine, but I've received numerous errors that are
similar on later and on previous versions of the file. Also, now when I open
one that is not corrupt and try to save it as a new file name, excel crashes
altogether.
This is a very complex spreadsheet and I'd hate to have to rebuild. Anyone
know what the problem might be? Decreasing the file size is not an option in
this situation.
Thanks,
Teri
Microsoft Office