Using Excel 2007, I have a rather complex file which contains many named
references macros and calculations. This morning, I expanded the ranges
within the name manager to accept 4000 rows of input that I paste into one of
the worksheets. Everything was working perfectly, until I saved, closed then
re-opened the file. Now, I get the error message "Excel found unreadable
content". Thereafter I am forced to either close or accept changes which
wipe out all of my formatting on every sheet (20+). I found a reference
elsewhere related to the "Current Time Member" and Key Performance
Indicators, when using a pivot table. This file does not have a pivot table,
however. I'm not certain it's related, but I was also getting an error
message about too many formats as I pasted 3000+ rows and roughly 20 columns
(70,000 + cells). Any thoughts on this?
Thanks in advance