[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Error in Excel 2007: "Excel has found unreadable content in this file ..."

Posted on 2011-10-28
4
Medium Priority
?
662 Views
Last Modified: 2012-05-12

I have a real problem here. I create weekly reports with a macro in Excel 2007 that saves the files as an XLSM file. Initially it re-opens fine. But if I make any changes to it and re-save, then when I open it next I get an alert that say something like: "Excel has found unreadable content in this file ..." when I click out of it, it then proceeds to delete all of the shapes on one of the sheets. This is a huge problem because most of the shapes are buttons with macros that are crucial to working with the report.

Does anyone know what is causing this and how do I fix it?

Thanks,
John
0
Comment
Question by:gabrielPennyback
  • 2
  • 2
4 Comments
 
LVL 26

Expert Comment

by:redmondb
ID: 37048509
gabrielPennyback,

I've seen something similar happen, but in my case it happens very rarely and seems to be associated with pivot tables and XLS files. Unfortunately, unlike you, I've not been able to reproduce it.

Any chance that you could post an example of this - presumably with test data? If not, could you give more details about the original file (a copy of the file with all data removed would be useful) and the subsequent changes you make.

Also, could you try saving the original file as an XLSB and then see if that makes any difference by make your usual changes?

BTW, as you may have discovered, there are a quite a number of Hot Fixes for this error. Without more details, it's not possible to narrow down one that might apply to you.

Thanks,
Brian.
0
 
LVL 1

Accepted Solution

by:
gabrielPennyback earned 0 total points
ID: 37048606
Thanks, Brian. I'm going to be gone til November 7, I posted this now on the off chance that it was something simple and then I could put the issue to rest before leaving on vacation. When I get back I'll try to put something together that will be complicated enough to produce the error. Thanks for your eagerness to help.

John
0
 
LVL 26

Expert Comment

by:redmondb
ID: 37048632
John,

Lucky sod! I don't want to postpone your departure, but I suggest you close this question (by requesting 0 points to be allocated to yourself). Then when you return you can open a new question, linking to this one.

That way, you'll have a fresh question which is more more likely to get a quick response than if you simply posted an "I'm baaaack" message in an old question.

Regards,
Brian.
0
 
LVL 1

Author Closing Comment

by:gabrielPennyback
ID: 37123882
I've been gone for 10 days and as per Brian's suggestion I would like to re-post it, perhaps with an example workbook.

Thanks, John
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question