Macro cannot run after the excel file's size becomes bigger?

Question

I recorded a macro for account reconciliation process. In one excel file will be included more than 10 accounts. I use the same macro for each account to transfer respective data into the file. After 8th account is completed by using the macro, the file size become 44,000 plus KB. Then, the macro cannot run anymore and this message box appeared; "Excel cannot complete this task with available resources. Choose less data or close other applications". How to solve this problem?

Answer 1

Increase the memory of your machine or have a different spreadsheet for each account. You can create a different spreadsheet to get the account summary for all your accounts, even when they are in a different spreadsheet.

Answer 2

in case you may a technique or the different convert an Excel spreadsheet record to run as a separate, standalone piece of utility as an EXE, which would be one heck of a feat, one that i could truly prefer to work out. i'm specific it quite is achievable, yet have not heard of or seen it ensue yet in my view. besides the indisputable fact that, so a techniques as i understand, you may no longer run an Excel macro-enabled record without the quite software, because of the fact the XLSM record isn't a standalone software in itself. quickly: No, you like Excel or nicely suited software which includes OpenOffice (unfastened) until eventually you will hit upon a thank you to transform it to a standalone EXE record. EDIT: beneficial locate garbo. I easily did no longer are attentive to it replaced into achievable and that there have been Excel to EXE courses obtainable (wager I could seek next time, huh? lol). So coloration me corrected.