I have a number of spreadsheets that contain a reasonable amount of data, formulae and macros (average file size between 1500-1900 KB). They are saved on a SharePoint site for the users to access the files and save their work.

One of the spreadsheets has suddenly started to show an "Out of Memory" message when you open the spreadhseet in Edit mode and then click "Don't Save" (It is fine when you click "Save" for some reason).

When the message appears you have to click "OK" 3 times and then it disappears and Excel closes the file and it seems ok, apart from the fact that this message is clearly showing something it not ok.

I have looked online and found a number of reasons that this message could be displaying but none of the fixes work (and some I don't understand).

I have actually had this happened before and I had to rebuild the entire spreadsheet, but this is not a long term solution.

Any help would be greatly appreciated!

Thanks
MissDB