change link path when open destination file


A

AskExcel

Hi,
the destination file is used by different party. we email each other the
destination file to update data where each party has its own source file.

my source files are at 'z:\shared\excel' but when i open the destination
file, the path is defaulted to 'c:\calc\checking\data'. there are many cells
with link to source files. i have worksheet link to several sources file at z
drive.
may i know how to change the path to the path i want when i open the
destination file? currently i use find and replace. it is very tedious and
manual.

need advice.
thanks
 
Ad

Advertisements


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