copy linked documents (2 files)

  • Thread starter Thread starter stan clark
  • Start date Start date
S

stan clark

I can't quite figure out how to solve this... so here goes...

I'm making a report template in Word that has several links to an Exce
spreadsheet. When finished, I would like to be able to reuse thi
combination (ie: make copies of both files) while maintaining th
links. However, if I copy the Excel file, it is not linked t
anything; if I copy the Word file, it maintains the links the origina
Excel. Does anyone know how to solve this?? Thanks for your help
 
FYI - I tried recording a macro to update the links automatically, bu
that doesn't appear to work. Does anyone copy/reuse their linke
Word/Excel spreadsheets? I know there's got to be an easier way than
going through each time and updating the links manually! Thanks
 
Back
Top