Spreadsheet Crashing

[thebuzzman15]

I built a spreadsheet to run my business with many tables, macros and formulas. It is located on SharePoint, I am using Autosave and the size is about 8 MB Large. Recently my spreadsheet has mysteriously starting doing the following things:

1. Closing down as soon as I open it
2. Giving me the Error "Document Not Saved" when I try to close it

What is strange is that these things only occur after I close and open the spreadsheet 4 to 5 times in succession. It saves perfectly and all the Macros seem to work the first couple of times I open and close it. I am forced to revert back to the previous saved version when this happens and I loose much of the data that I entered into the spreadsheet. When I disabled the Macros on my Trust Settings this issues does not seem to occur.

Does anyone have any ideas on how to resolve this issue?

 

[Michael M]

Have you tried it on your machine rather than on Sharepoint, and see if it still happens ?

 

[thebuzzman15]

I have. The same issue occurs and I also need it on SharePoint

 

[Michael M]

This might help resolve the issue

Clearing Cache VBA

I have several workbooks that I update each morning and load to SharePoint for multiple users to view. Recently, there has been an issue with the workbooks not displaying the updates that were loaded. Having the user clear their cache resolves the issue. My question is, is there any VBA that...

www.mrexcel.com