Excel with SP2 corrupts worksheets with pivot tables

[Possum Stu]

We have a worksheet on our server that was created with Excel 2004
11.1.0. It is opened and used by several 11.1.0 users, but sharing has
not been activated. It is set to save an autorecovery file every ten
minutes (default?), plus it is set to save a back-up upon saving. The
worksheet is also protected with a password.

The spreadsheet has many pivot tables. Opening the spreadsheet, you
wait for all the tables to get updated and calculated.

After I upgraded to SP2, I found I could open this spreadsheet and make
changes, but once I saved and closed the file, neither I nor anyone
else could open it again. We would be prompted for the password, then
told Excel was "unable to read file." This occurs for both SP2 and 11.1
users.

I tried copying a duplicate of the original to the desktop, then opened
and saved with SP2 -- same error. I tried turning off autorecovery --
same error. I checked on and off the analysis toolpak add-Ins -- same
error.

Finally I uninstalled Office, then reinstalled it upgrading only up to
11.1.0. Now the spreadsheet works and saves as it did before. I can
only conclude something in SP2 is at fault.

There is no obvious avenue to report this problem to Microsoft, so I'm
posting it here in the hope someone sees it and passes it on. I've seen
a reference on the PC side to microsoft support article 819853 -- maybe
this bug transferred over to the Mac side with SP2?

 

[JE McGimpsey]

There is no obvious avenue to report this problem to Microsoft, so I'm
posting it here in the hope someone sees it and passes it on. I've seen
a reference on the PC side to microsoft support article 819853 -- maybe
this bug transferred over to the Mac side with SP2?

This is the appropriate avenue - MacBU supposedly monitors these groups
for bug reports.

I can't reproduce this on any of my remote servers, but I'm sure this
will be logged for investigation if there are a number of such reports.