Out of Memory message

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

What do the macros do?

They do a number of things but the macros are only activated when you click on something so there are a number of little macros for example that hide rows/columns, and then unhide rows/columns, that bring up forms to then create a pdf reports etc. These are only activated when you double click on specific cells.

At the moment, however, all I am doing is opening the sheet in Edit mode scrolling up and down a little (i.e. not making any changes and not activating any macros) and then closing,but clicking "Don't Save" and the message appears