I have been successfully using a data link to connect two Excel files, one on my local drive and the other on a mapped network drive. Now, when I open the “local” file (which has the data link and formulas that use it), the cells with the linked data display the correct values, but then revert to a #VALUE! error when I click Update or Don’t Update on the alert window. When I check the status of my data link and update values, it reports OK, but the cells do not update.
Below is a sample of the formula that relies on this data link. I use a very similar formula in several other files without any problem. This file (and formula) was functioning just fine and suddenly stopped.
=OFFSET(INDEX('I:\Volunteers\Community Emergency Response Team\[CERT registration.xlsx]REGISTRATION'!BE$2:BE$9999,MATCH(H13,'I:\Volunteers\Community Emergency Response Team\[CERT registration.xlsx]REGISTRATION'!BE$2:BE$9999,FALSE)),0,-16)
Many thanks for any suggestions anyone can offer!
Below is a sample of the formula that relies on this data link. I use a very similar formula in several other files without any problem. This file (and formula) was functioning just fine and suddenly stopped.
=OFFSET(INDEX('I:\Volunteers\Community Emergency Response Team\[CERT registration.xlsx]REGISTRATION'!BE$2:BE$9999,MATCH(H13,'I:\Volunteers\Community Emergency Response Team\[CERT registration.xlsx]REGISTRATION'!BE$2:BE$9999,FALSE)),0,-16)
Many thanks for any suggestions anyone can offer!