When trying to delete an Excel column, I get an error that says "There is not enough memory to complete this action". What's happening?
When trying to delete an Excel column, I get an error that says "There is not enough memory to complete this action". What's happening?
That error is frequent, especially in the use of different formats in your book. Always remember that each column format (be it color, font type, etc.) is an extra process for Excel plus the copy action.
The troubleshooting I recommend is to verify that you do not have automatic update of links or duplicate conditional formats, also verify that you do not have extra cells that only take up memory, remember that if there is a blank row, it must be really empty and the scroll should not detect; I see that if he detects it.
I reiterate that it may be something with the excessive formatting of your book, I recommend you "clean" the document as much as possible by strictly taking what is necessary to avoid memory overflows. Delete all the rows, the scroll should only show you what you have data.
Greetings, Nico