I have a sheet with a ton of vlookups to remote workbooks. They all appear to be working fine, except that sometimes I'll open one of the workbooks referenced, and the cell that references that wb doesn't update it's formula. For example, if I have this formula in my cell;, whn I open the PCA History workbook the formula changes toPlease Login or Register to view this content.
But sometimes, for some of my formulas, when I open the WB it's not recognized by the formula. If I delete just the file path, Excel wakes up and recognizes that the open workbook is the one it's supposed to be looking at.Please Login or Register to view this content.
Can anyone explain this behavior and tell me how to keep my formulas focused on the wBs they're supposed to be looking at?
Bookmarks