I have a formula in a workbook. When the sheet that I am getting the updates
from are in the same workbook it works great and it updates immediately when
I make a change. When I try to get an update from another workbook, I have to
edit this formula before it recognizes any changes.
THis is the formula I am using:
=IF(ISERROR(VLOOKUP($A8,'E:\Debbie\[OCT 07.xls]Copay Oct
29-31'!$A$1:$R$386,11,FALSE)),"",VLOOKUP($A8,'E:\Debb ie\[OCT 07.xls]Copay Oct
29-31'!$A$1:$R$386,11,FALSE))
What am I doing wrong. I want it to update the minute I make a change in the
previous workbook.

--
Debbie Pringle

When in the same WB, when you make the revision, and hit <Enter, you're
actually re-calculating the *entire* WB, *including* the Vlookup() formula
on the other sheet.

This of course *doesn't* happen when you're working on 2 separate WBs.

Just try hitting <F9 to re-calculate the WB you're in at the time.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"ywcaofjamestownDebbie"
wrote in message ...
I have a formula in a workbook. When the sheet that I am getting the
updates
from are in the same workbook it works great and it updates immediately
when
I make a change. When I try to get an update from another workbook, I have
to
edit this formula before it recognizes any changes.
THis is the formula I am using:
=IF(ISERROR(VLOOKUP($A8,'E:\Debbie\[OCT 07.xls]Copay Oct
29-31'!$A$1:$R$386,11,FALSE)),"",VLOOKUP($A8,'E:\Debb ie\[OCT 07.xls]Copay
Oct
29-31'!$A$1:$R$386,11,FALSE))
What am I doing wrong. I want it to update the minute I make a change in
the
previous workbook.

--
Debbie Pringle