Sharing Linked Workbooks

I

IowaTracy

Hi,

I have several workbooks which are linked together with various
formulas. Once all the workbooks are opened on my PC everything works
great but when I send the workbooks to someone else even though they
save them and open them properly on their PC, the links look for
workbooks on my PC.

Is this a common problem? What am I missing and what can I do so that
these workbooks open and work on another's PC the same way they work on
mine.

Thank you
 
D

Dave F

If the formulas which reference other workbooks are using filepaths specific
to your pc, then when someone on another pc tries to use the workbook, Excel
won't know how to link the various cells.

Also there are a number of formulas, such as INDEX, COUNTIF, etc. which
don't work if they reference closed workbooks.

Without knowing the formulas that are not working it's hard to diagnose the
issue.
 
I

IowaTracy

Thanks Dave for the reply. I have confirmed that the user is opening u
the associated workbooks.

Sounds like just re-linking with the correct information such as driv
letter, path, etc. should do the trick.

Problem is that working with people halfway across the country who ar
not PC savy is tricky.

Thanks again...

Trac
 
D

Dave F

Is the workbook stored on a network drive that all users have access to?

If so, then they should only open the workbook when it is stored in that
shared drive. Make sure your users aren't saving the workbook to their local
drive.
 
Top