Speed of excel

[Bandito1]

Hi all,

I'm making a dashboard in Excel that uses several other excel worksheets.

I'm asking myself what is faster;

Pulling data out of several other excel worksheets with for example index / match and do calculations in my dashboard OR
Do the calculations in the other excel worksheets and link the results with my dashboard.

Anyone knows what is smarter?

Would like to keep my dashboard as fast as possible.

[avk]

Without seeing your file it is very difficult to say anything.

[Bandito1]

Was asking more in general.

It combines many different files with sensitive info, so impossible to show the files here.

[MrShorty]

One general thing I see -- lookups (especially the linear "exact match" lookups that everyone seems to prefer) are very slow and are a common bottleneck. They are even slower when they are performed on a closed workbook. As a general rule (and every general rule of thumb will have its exceptions), whichever strategy will reduce/minimize the number of lookups (especially on closed workbooks) will likely be faster.

[avk]

The Pivot table is good option's.

[MarvinP]

Hi Bandito,

I was thinking that "Volatile" functions really slow things down. Some normal Excel functions are Volatile. Read more about then and speeding up you sheets at:

https://trumpexcel.com/suffering-fro...-spreadsheets/