Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup not refreshing data values
Hi,
I have too worksheets. One is a master file of information. The second one pulls in data from the master file using vlookups. When building the vlookups for the first time, the data populated as expected. However, I made a change to the master file, saved and closed it, but when I opened up the secondary file, the data did not update. When I open up the master file, then the secondary sheet updated correctly. Auto-calculate is already turned on. There is protection built into the secondary sheet so that users are unable to update the sheet - could this be causing the problem? If yes, how can I get the secondary file to refresh - without opening the master? Thanks, Mary-Lou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: VLOOKUP not refreshing | Excel Worksheet Functions | |||
Function Values Not Refreshing | Excel Worksheet Functions | |||
refreshing ComboBox values | Excel Programming | |||
Refreshing drop down cell values... | Excel Worksheet Functions | |||
Auto Refreshing - values | Excel Programming |