Copying a template to another PC

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I have created a template on my PC that automatically will
refresh data from another workbook when the templat is
opened. How can I copy both workbooks to another pc so
that when they repalce the data in the main workbook it
will refresh the data when they open the xlt.

This works fine on my pc, but willnot refresh that data
after both work books are copied to a different PC.
 
Are you doing this with formulas?

It sounds like the links may point back to the original workbook--not the one
you copied.

I think that if you store the template and the main workbook in the same folder
(and then copy them to the same folder on the new pc), excel will keep the links
nicely.

You may want to look at Edit|Links to see if they are pointing correctly. If
they're not, change them to point at the correct workbook.
 
Back
Top