Accelerate workbook performance without rebuilding indirect formulas

[jaryszek]

Hi,

cross post here:
https://www.excelforum.com/excel-pr...nce-without-rebuilding-indirect-formulas.html

i am using many indirect references for listobjects within formulas.
I think this is causing recalculation of whole workbook all the time (when one formula is changed).

I have to rebuild macro for downloading tables from database (not column but rows approach to eliminate all indirect references) and rewrite all formulas
(about 1500 formulas). But this will take a little time.

Maybe there is an option to have a fix not requiring changing whole workbook model?
Like calculation (second option):

https://www.excelforum.com/attachme...ebuilding-indirect-formulas-screenshot_10.png

Or turn on calculation only when sheets is activated.
Or other workarounds for this?

Creating workbook model i didn't think that it will be so enormous that it will cause worst overall performence (all the time calculating in the background).

Do you have any solutions for this?
Please help,
Jacek

 

[jaryszek]

hi,

anybody please?

Jacek

 

[jaryszek]

Anyone?

Jacek

 

[RoryA]

Your question is basically like ”how do I make this car go faster without taking my foot off the brake?”. So my question is why does your foot have to be on the brake? Unless you have a very good reason, the only sensible answer is the one you're trying to avoid.

 

[jaryszek]

Hi Rory!

thank you. Ah this is what i afraid off.
The seonc my idea is to loop through all named ranges take them formulas and replace all "indirects" to directly reference to tables.

But yes rebuilding is must have for the future.
Thank you!
Jacek