Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 12th 05, 04:50 PM
Tim Marsden
 
Posts: n/a
Default "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   Report Post  
Old October 13th 05, 10:33 AM
nojetlag
 
Posts: n/a
Default

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   Report Post  
Old October 15th 05, 02:10 PM
Jon Peltier
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send Excel File As Read Only jgarzoli Excel Discussion (Misc queries) 1 October 3rd 05 07:48 PM
Unable to create any link/hyperlinks in a particular excel file Nabanita Excel Discussion (Misc queries) 0 June 21st 05 11:52 AM
Opening an Excel File jedi249 Excel Discussion (Misc queries) 5 April 16th 05 11:44 PM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 09:21 AM
Network access to file - read only property AL Excel Discussion (Misc queries) 1 December 2nd 04 02:22 AM


All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017