Error "Excel found unreadable content" due to autofilter

**JChandler22** · 06-21-2010, 05:41 PM

Hi All,

Please see attached (forum_upload2.xlsm) - this is a stripped down version of my actual workbook but it produces the exact same error.

The different sections on the 'Cost Summary' tab each have a button on the left side which show/hide the items within each section on three level: fully shown, partially shown, or fully hidden (depending on item value). If you play with the buttons, you'll see exactly how they function. It's much like Excel's built-in grouping function, but it has three levels instead of two. The dots on the button show which level the section is at... 1 dot = fully hidden (no items shown, just section totals); 2 dots = partially shown (only non-zero items shown); 3 dots = fully shown (all items shown even with zero values).

Also, the single isolated button at the top right controls ALL sections at once in a similar fashion. Again, if you play with it for a few seconds you'll see what it does.

The problem I'm having is this: When I use the button at the top right and stop at the 2-dot level (all non-zero items shown), then save the file, quit excel, and try to go back into the file I just saved, I get the following error:

Please Login or Register  to view this content.

If I click 'Yes', the file opens and all of the shapes/buttons are missing, and the following message appears in Excel:

Please Login or Register  to view this content.

To reiterate, this error only occurs when I save the file at the 2-dot level. If you look at the VBA behind the button in the top right, this is the only section of code that uses the autofilter command:

Please Login or Register  to view this content.

I don't get the error when I save; I get it when I close out of Excel then try to come back into that newly saved file. Can others recreate this error, and if so, do you know why it might be happening?

Thanks - I greatly appreciate any insight.
Jeff

Also - I'm using Excel 2007 and the attached file will (I think) only open in Excel 2007.

**JChandler22** · 06-22-2010, 08:50 AM

Has anyone been able to duplicate this error? Wondering if it's just on my end...

**JChandler22** · 06-29-2010, 04:11 PM

At the risk of being annoyingly persistent, I'm going to give this one more shot. The long-winded explanation hasn't proven to be effective, so I'll try asking the question a little more simply:

My macro runs an autofilter command. The command works as expected, and I can save the file just fine. However, when I try to re-open the saved file, I get the "Excel has found unreadable content..." error message, and I can't figure out why (though I've isolated it to this autofilter functionality). Does anyone know why this might be happening?

The autofilter code is:

Please Login or Register  to view this content.

Thanks very much! (also, if you want more detail or need to see a sample workbook, see my first post in this thread)

**jryan15** · 12-04-2012, 11:14 PM

I'm also having the same kind of trouble any chance someone has any advice? thanks!

**arlu1201** · 12-05-2012, 02:38 AM

jryan15,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.