I have a large Excel model (250mb). This file has been running on Windows 7 + Office 2010 without problem for the past 3 years.
Want to test the model on Windows 10 + Office 365 but ran into a snag. Yesterday I opened the file, imported some data, saved the file, ran the model and saved the file, no problem. Then I opened the file again, imported some data and on saving Excel just shut down. No message no nothing. Restored a backup file, imported the data, saved the file, ran model and saved the file, no problem.
Today I open the file. Import the data and on saving the file Excel shut down. Restored a backup file and open file. Success up to here. Import the data and on saving the file Excel shuts down. Restore a backup file and open the file. Again success up to here. Without doing anything, I just click the save button and Excel shuts down.
The moment the file tries to save Excel shuts down. No message or anything. Restarting Excel tries to repair the file and if it gets the file open it just shuts down again when trying to save.
This happens on clicking the save button or when trying to save out of VBA code.
Any ideas?
Bookmarks