I only fixed the bug yesterday. You will need to wait for the next SR to be released.

Hi Mike,

I'm using 10.1, so shouldn't that mean it's fixed for me? It doesn't appear to be :-(

Kev

This bug was submitted as TFS33952 and was fixed in versions 9.2 and later. Unfortunately, I did not find a good workaround for this issue, so you will have to wait for the next service release.

Okay, this may be a clue. When I open that spreadsheet in excel 2010 I get  a message that it came from an internet source and editing was disabled. I'd ignored it previously as I didn't need to edit the file. This time I told it to make the file editable, then saved it. The file then loaded okay with the original code. So, might be worth investigating what that error means?

Could be a red herring though - I compared the original file and the file saved by excel, and there were numerour differences (more different than the same, to be honest).

Hi Matteo,

That doesn't seem right - doesn't that just add a new worksheet with the given name? I gave it a try anyway. First time I got an exception due to having a '\' in the name of  a sheet (my filename is a full path (eg, c:\temp\aldebaran 132wb.xls) rather than just a filename) which kind of fits with the whole "add sheet not load file" thing. Tried it with just the filename and it just added a sheet with that name.

So, not much use I'm afraid. Did you try it yourself?

Kev