If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report.
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
"Unable to read file" error message when opening a Excel filethat contains a PivotTable report.
I haven't seen this problem, but I've had other issues with Excel's
built-in autorecovery feature. Instead I use Jan Karel Pieterse's AutoSafe add-in, which is available free at http://jkp-ads.com. This might help eliminate one cause for the error. Andreas - What code are you using to manipulate the pivot table? It's more stable to create the pivot cache first, then build the pivot table from that. The method that builds the PT from scratch in one statement seems more efficient, but in terms of downtime, it's definitely not. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ nojetlag wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking v Embedded | Jim Bunton | General Discussion | 5 | August 10th, 2005 11:09 PM |
.jpg .gif .bmp file associations gone, upgrade from Office XP to 2 | fbartrom | Setup, Installing & Configuration | 13 | February 25th, 2005 01:33 PM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |
Unable to read file | Glenn Tocha | General Discussions | 2 | June 7th, 2004 03:26 PM |
"Unable to Read File" | Kirk | Setting up and Configuration | 1 | November 30th, 2003 05:39 PM |