Updation of formula and reference in different Workbook

[vidplaylist]

Hi,

I have one workbook (Name a) which is summarizing(consolidating) the results from three other workbooks (Name b,c,d). How i can make sure that the formula's and references will update in a work book (Name a) without opening other three workbook.


Thanks,

 

[Andrew Poulsom]

Your formulas should update when the workbook is calculated.

 

[vidplaylist]

How come without opening the other three input workbooks?

 

[Andrew Poulsom]

What are the formulas? I assume they are not updating automatically for you.

 

[vidplaylist]

I am devolping a budget and now i want to consolidate budget number in a seperate workbook and excel is not allowing me to put a reference to a seperate workbook.

Simply saying how i can put formula or reference to a different excel workbook?

Hope it is now much clear.

Thanks in advance,

 

[Andrew Poulsom]

What do you mean by "excel is not allowing me to put a reference to a seperate workbook"? The easiest way to enter a linked formula is to open the source workbook and use your mouse to point at the references you want to include.

 

[vidplaylist]

There was something wrong now reference is working. but still to update the reference from other closed workbook i have to go on reference cell and have to press F2 and hit enter to update the reference link.

Is there is a way that my reference get updated without doing this step.

Thank you,

 

[Andrew Poulsom]

Have you tried Edit|Links|Update Values? You shouldn't need to do that because the links should update when the workbook is calculated. What's your formula?

 

[vidplaylist]

My formula which i am going to put is somthing like this.

=IF(ISNA(VLOOKUP($B159,'SheetB'!$B$25:$Q$478,MATCH('BP90'!D$4,'SheetB'!$B$4:$Q$4,0),FALSE)),0,VLOOKUP($B159,'SheetB'!$B$25:$Q$478,MATCH('BP90'!D$4,'SheetB'!$B$4:$Q$4,0),FALSE)).

How i can use Edit|Links|Update Values in Excel 2007

thanks for your all help.

 

[vidplaylist]

This formula i have on sheets in same workbook. But i am going to put same to reference data from different workbooks.