I have a very large Excel file that I am building, including over 33K rows, formulas, macros, etc - the file size is around 25,000 KB. It seemed to be working fine - I was finished with the workbook that was for January data and then tried to do a file, save as to create a copy for the February, etc data.
Then everything went bad... I was able to copy Feb and Mar, but now Excel does not want to save any of the three files and I cannot move on to April, etc. I can get into each file, but it is very slow opening, I can change data, but not save, and it will no longer automatically calculate, even though the option is set to automatic. All files are running very slow and I get the "Excel is not responding" error whenever I try to save. .
I have tried to delete macros, but that does not change the file size significantly. I have tried deleting unused rows and columns. I have tried to copy the sheet to a new file, but get the "not resp" error again. Do you have any idea what is causing this, and more importantly, how to fix it?
Thank you in advance for your expertise!