Software

Ask something
Discussion Locked

Excel 97

0 helpful
5 replies

by icetub

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a spreadsheet that has over 3000 rows that is 3 columns wide and upon inserting a row anywhere it gives me a page fault error and bombs out excel when I try to save it. However this doesn't happen if I add information starting with first rowavailable at the end of the worksheet. Is there a fix for this?

5 replies

by bishopca

How much memory do you have availble to Excel? A spreadsheet that big could require a more memroy than you have available.

Using Excel goto Help About System Info to see how much memory is available when the spreadsheet is open.

Try this - (MAKE A COPY OF THE FILE FIRST)add the data to a bottom row and then sort the data to organize it. Does the same problem occur?

If not - try defragmenting. Good Luck

This discussion is closed to new replies.