Software

Ask something
Discussion Locked

Excel 97 Problem - Access Violation

0 helpful
1 reply

by pohga

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am experiencing problems with my excel spreadsheets that are using pivot tables. When I try to save the spreadsheets, I encounter either an error message saying that the file could not be saved or an access violation message. After that, the file becomes corrupted & I am unable to open the file again. This problem seems to occur only when pivot tables are used in the spreadsheet. I am running Excel 97 on Windows NT Workstation 4.0 with 256MB of RAM. I have tried increasing the virtual memory but that did not work. Any help is greatly appreciated.

1 reply

by tsigam

Well, this a work around. To resolve the problem I opened the file using Lotus 1-2-3 97 version. I saved the file in Excel format and I was able to open the file using Excel 2000. The only thing she lost was her Chart, but the rest of the data staysthe same. So you might want to open the file using a different application. I had user user who experienced the same problem. she saved her Excel file and when she tried to opened it...I would say "Unable to read file." We could do a quick view of the file by "right-clicking and clicking on "Quick view" You are running Win NT 4. Place the file on your desktop and right click on it. You will see "Quick view" option....but you can't edit the file or anything, it will not allow that.
I hope this helps...I could find any other way to resolve the problem...

This discussion is closed to new replies.