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)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!