indirect formula

Hi,

I have attached a file where the formulae in the shaded section perform a lookup on sheets using the volatile indirect function. A new sheet is added every month. This leads to a lot of recalculation every time a change takes place on the workbook (somehow there is no time delay on my Mac - because of Excel 2008??).

Can anyone think of another formula instead of what I used? I am trying to make the workbook truly interactive and would like to avoid macros, or set the calculation to manual.

The file and URL link are attached.

Appreciate some help.

Thanks

MK

No attachment

There is no attachment with post

Vishesh's picture

It might solve

Though there is no attachment to refer to but one solution could be that you can copy and paste them as values after putting in the formula for a sheet. Similarly put the formula for the new sheet and then copy paste them as values.
The reason being that once they are copied as values they won't be recalculated.

Vishesh's picture

Indirect

No attachment is there with your post.