Hi everyone,
I have created an Excel file, which consists of several sheets and innumerable, partly very complex formulas, which are interlinked with each other.
One of the sheets (the one where all the calculations are done) uses the whole area of the worksheet for a reason I can't explain. So the scroll bars do not grow dynamically but are on the smallest size.
The Excel also needs about 3-4 min to open and is 4MB in size.
As soon as I try to delete a row or column, I get the message that there is not enough memory.
I am using O365 ProPlus 64 bit (version 1808). The laptop has 16GB Ram, but Excel uses a maximum of 3GB.
Do I have a way to save my tool or do I have no choice but to rebuild it? (The effort for the new creation would be about 1 working day).
Can someone explain to me why the error occurs, so that I can avoid it in the future?
Thanks a lot!
wit4r7
Bookmarks