vlookup to other files and #NAME error

  • Thread starter Danielle From Ottawa
  • Start date
D

Danielle From Ottawa

Hi!

I have a bunch of vlookups in a summary speadsheet that references 15
separate spreadsheet files in the same folder. There are 20 users that the
set of files is working fine for. But for some reason one user gets the #NAME
error, until he opens all of the associated files, at which point the data
all fills in.

I've had this happen to me occasionally on other files, but I've been able
to work around it. Does anyone know how to correct?

Thanks
Danielle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top