General discussion

Locked

Excel 97

By icetub ·
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?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel 97

by Curacao_Dejavu In reply to Excel 97

Which version of Office 97 are you running, no sp, sp1, or sp2 ?
Try upgrading to sp2.

Leopold

Collapse -

Excel 97

by icetub In reply to Excel 97

Poster rated this answer

Collapse -

Excel 97

by bishopca In reply to Excel 97

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

Collapse -

Excel 97

by icetub In reply to Excel 97

Poster rated this answer

Collapse -

Excel 97

by icetub In reply to Excel 97

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums