Home » Forums » Open Source Learning Center » Question and Answer

indirect formula

Submitted by mkapashi on 28 April, 2011 - 23:43

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

‹ Urgent - FINDING Last Row OF data in excel in multiple sheet tabs and creating a new summary tab with last row of data help me to solve this issue ›
»

No attachment

Submitted by Anonymous on 4 May, 2011 - 09:21.

There is no attachment with post

»
Vishesh's picture

It might solve

Submitted by Vishesh on 29 April, 2011 - 15:07.

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

Submitted by Vishesh on 29 April, 2011 - 08:06.

No attachment is there with your post.

»