Hi, I have 4 .xlsb workbooks with a lot of references between them and trying to reduce size to improve performance etc.
The sheets also contain tables with formulas to fetch data from other Workbooks and sheets. Some of them 40 columns wide
and 10.000 rows where all cells contain data or formula.
What can I do and how?
Already done:
* converted to .xlsb as stated above which was the most effective adjustment so far
* CTRL+END and removed all possible not needed data with "Clear All"
* Using INDEX instead of VLOOKUP in formulas (not reducing size maybe but improving performance from what I understand)
* Removed all unnecessary formatting
* some other stuff....
Bookmarks