Excel found unreadable content... after Picture is too large and need to be truncated
Posted on 2013-11-26
Hello Experts, I have a very large Workbook consisting of 31 sheets, 16.000 lines of code in 10 modules, 38 userforms for UI and over 2,000 range names.
It has been working perfectly for over 4 years, then few weeks ago I started having big problems when opening it. I get the infamous message: Excel found unreadable content... and 80% of the formulas are turned into values when I trust it and open it.
I've noticed that most of the times when it corrupts I get the "Picture is to large and needs to be truncated" message upon closing it.
Of course I have backups and automatic procedures for importing all data from the old file to the new one, therefore the issue is not vital but still it worries me quite a bit.
Is there a way to find out what is corrupting the file? Can I solve the Picture is too large... error when closing?
Any help would be deeply appreciated