VLOOKUP LINKING

[mrbeanyuk]

Hi there.

How do I update VLOOKUP data links when transferring from a office PC to a laptop?

There are several thousand links to several source spreadsheets and these sources will obviously change when moved to an different file path.

The solution of changing each path is just too long!

Any ideas?!

 

[Jon von der Heyden]

Try:

Edit -> Links -> Change Source

Regards,
Jon

 

[mrbeanyuk]

This only changes the link to individual cells and I will have to do this to over 3000 cells!

There has to be a bulk change possible?!