Hi all,

A while ago, I posted up a thread regarding a formula that could pull through data by referencing a sheet name in a cell - and you good people solved the problem by recommending I use the INDIRECT function.

Initially the document was pretty small and only had a few instances on the INDIRECT. However, over the weeks the document has grown and it is now running very slowly. Can anyone suggest an alternative to the INDIRECT function as a number of people in the office have very slow machines and the documents is becoming more of a hinderance than a help.

Having done some research I've found out that INDIRECT is 'volative' as it continually calculates every cell and hence the slow down in speed.

The formula is basically:

Code:

INDIRECT(A93&"!B4"))

...although I am running a few IF(ISERROR type precursors to keep everything looking clean.

The long and short - can anyone suggest an alternative formula that isn't so volatile?

TIA,

SamuelT