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
|