I have searched everywhere to solve this problem and I have not been able to do so. I have an Excel file that I created for work, it has several macros (about 20) and a few button controls (6 sheets with 3 buttons for each sheet...the buttons trigger the macros, about 4 macros for each sheet).
There are a good bit of vlookups in the files. Basically, I paste about 5 reports to the tabs in the sheet and then use vlookups to produce the report how I want to produce it.
The file is only 1.3 MEG in size. But when I try to save it, it will not save. I have always had problems saving the file, but usually after 5 minutes or so it would finally save. But now I am at the point where it will simply no longer save. This is a critical report that I run weekly and am dead in the water since I can't save it.
I have tried it on many different pc's and it does not work on any PC. Each week I copy the file to a new file and change the filename and keep rolling the file to the next week. THE FILE JUST WILL NOT SAVE. I left it on my desktop for 42 minutes and it was still hanging.
I can send the file to you if you like.
I have tried the following: ensured journaling is off, deleted temp files in windows and user temp directory, rebooted, logged in my laptop as different users to see if it was a profile issue, tried it on my desktop pc, tried repairing it in Excel, tried saving as a different filename and nothing works.
Any idea?
There are a good bit of vlookups in the files. Basically, I paste about 5 reports to the tabs in the sheet and then use vlookups to produce the report how I want to produce it.
The file is only 1.3 MEG in size. But when I try to save it, it will not save. I have always had problems saving the file, but usually after 5 minutes or so it would finally save. But now I am at the point where it will simply no longer save. This is a critical report that I run weekly and am dead in the water since I can't save it.
I have tried it on many different pc's and it does not work on any PC. Each week I copy the file to a new file and change the filename and keep rolling the file to the next week. THE FILE JUST WILL NOT SAVE. I left it on my desktop for 42 minutes and it was still hanging.
I can send the file to you if you like.
I have tried the following: ensured journaling is off, deleted temp files in windows and user temp directory, rebooted, logged in my laptop as different users to see if it was a profile issue, tried it on my desktop pc, tried repairing it in Excel, tried saving as a different filename and nothing works.
Any idea?