M
Mathew P Bennett
Good Evening Guys, Excel 2007
I have a query about Named Ranges and the associated calculation speeds.
I have a wb which uses a master sheet which runs to over 35,000 rows & only
15 Columns. I run another ss which has 5 vlookup columns referencing to the
master sheet.
Now I have been trying to use Named Ranges to make the vlookup's easier.(and
faster)
I have saved the same wb as three seperate workbooks, and have found the
following:
WB1: Named Ranges using offset & counta, file size
6.73mb Calc time >5 mins
WB2: Named Ranges using index & counta, file size
6.87mb Calc time 13 secs
WB3: No Named Ranges - Just Absolute Cell Referencing, file size 8.08mb
Calc time 04 secs
Is someone able to explain this, as I was under the mpession that it was
always advisable to use named ranges.
Thank you in advance.
Mathew
I have a query about Named Ranges and the associated calculation speeds.
I have a wb which uses a master sheet which runs to over 35,000 rows & only
15 Columns. I run another ss which has 5 vlookup columns referencing to the
master sheet.
Now I have been trying to use Named Ranges to make the vlookup's easier.(and
faster)
I have saved the same wb as three seperate workbooks, and have found the
following:
WB1: Named Ranges using offset & counta, file size
6.73mb Calc time >5 mins
WB2: Named Ranges using index & counta, file size
6.87mb Calc time 13 secs
WB3: No Named Ranges - Just Absolute Cell Referencing, file size 8.08mb
Calc time 04 secs
Is someone able to explain this, as I was under the mpession that it was
always advisable to use named ranges.
Thank you in advance.
Mathew