Well I have the same problem. Currently developing an application in
Excel (I would do it on SQL Server, but not my decision), so at the
moment struggling with the instable environment of VBA in Excel.
I do have 2 Pivot tables in this excel sheet. While working within it
all is fine. Then at night when I save it, I close Excel and try to
open the same file again. That time it works. Next morning I want to
continue, I get this "Unable to read file", initially I was getting
close to blame Symantec AV, but it really seems to be an Excel 2003
problem. I have all public available updates for Excel 2003 applied. Is
it possible that one of these "security" patches causes this very
annoying behavior ?

best regards
andreas


Tim Marsden wrote:
Hi,

I am get an "Unable to read file" error message when opening a Excel
file that contains a PivotTable report.
All the symptoms match microsoft support article 819853, except I am
using Office 2003 not 2002.
Is there a patch for the problem and how do I obtain it.

I do need to unprotect and protect the workbook and worksheets, and
not corrupt the file.


Regards
Tim