Data is not updating in Excel
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 |
Data is not updating in Excel
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 |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com