EXCEL ran out of resources error message

[Clint.C]

Hi @buzzmaster1 Ken,

I can certainly see why you need these issues resolved before you travel.

I too ran a dual Excel and Sheets for awhile. It was fun learning Sheets and the Google side of things.

I can’t speak to the web version of Excel as I don’t have any experience with that. However, maybe the following will help:

Regarding the “out of resources” error in Windows Excel, have you tried clearing the Excel cache solution that I posted about in this thread?

Regarding the large file size with your customized transactions fields, pivot tables and reports; I posted about an interesting Excel command I found last year called Check Performance. It has helped me reduce my Excel file size significantly and improve performance. I haven’t run into any issues using it.

How to reduce time to open a workbook, improve performance and reduce workbook size

Is your Excel workbook taking a longer time to open up lately? Would you like to improve the overall performance of the workbook? Are you interested in reducing the overall size of the workbook? I recently came across a command in Excel called “Check Performance”. The command will check for cells that have formatting and no data in cells which could be impacting performance. A simple example is where a complete row has color formatting and only a few hundred rows are being used. Given that a …

Clint