espenskeie
Well-known Member
- Joined
- Mar 30, 2009
- Messages
- 636
- Office Version
- 2016
- Platform
- Windows
Hi excel experts
I have a workbook that is filled up with lots of data tables, sumif and indexing formulas.
I know that these are heavy for my workbook. It takes about 15-20 seconds just to save the workbook.
1. Is there any better way of making those kind of lookups to avvoid killing the RAM and slowing down my computer?
2. Can I somehow measure the size of the load that I have in my workbook?
The workbook is only 12MB big, but the amount of heavy formulas in thousands of cells is what slows it down.
Best regards
Espen
I have a workbook that is filled up with lots of data tables, sumif and indexing formulas.
I know that these are heavy for my workbook. It takes about 15-20 seconds just to save the workbook.
1. Is there any better way of making those kind of lookups to avvoid killing the RAM and slowing down my computer?
2. Can I somehow measure the size of the load that I have in my workbook?
The workbook is only 12MB big, but the amount of heavy formulas in thousands of cells is what slows it down.
Best regards
Espen