I have a relatively small file used for work. It contains 20 worksheets (most have very little information, or none at all, which all work fine except for one of them. It WAS working fine, but now every time I try to add or delete a row (which I have to do often) Excel 'encounters an error and needs to close' when I try to save. I have tried copy/pasting the worksheet to a new workbook under a new name, I have tried deleting large chunks of it. I am no where near the information limit in terms of rows and columns. This document stops at Column I and Row 4500. There are no Vlookup links to other pages or other workbooks. It is very simple, and the only 'special features' or functions I am using are the SUM function and freeze panes on the first two rows. Please help. I need to be able to work on this file AND save it. Also, I am using Excel 97.
Software/Hardware used: Excel 97, Windows XP (32 bit)