Category Archives: Uncategorized

Creating a repeating (looping) workflow in SharePoint 2010

Creating a repeating (looping) workflow in SharePoint 2010.

The workbook cannot be opened as it does not contain any visible named items

I got a report from a customer who was having problems opening an Excel spreadsheet in Office Web Apps. They were getting the following error:

20130620Image01

When I tried to download it and open it on my desktop in Excel, I got this error:

20130620Image02

After that, I’d just sit there with the Excel client open but everything was greyed out. I was thinking that there might not be any way to recover the file, as it was last updated too far back. But fortunately, I poked around the Ribbon bar and found the following option:

20130620Image03

When I clicked that, everything showed up!  Whoo-hoo!

This link actually talks about the underlying reason as to why it happened, but I was more interested in mitigating the damage (which Unhide did just fine).

http://fendy-huang.blogspot.com/2011/02/unable-to-open-excel-workbook-as-it.html