Save problem for linked excel spreadsheet

[Guest]

Hi,

I have a word document with an excel document linked as an icon (and a table
of linked data from the spreadsheet paste special-ed below the icon in the
word doc).
Users need to save a local copy of the word document for each project they
undertake (master is stored on the intranet) - they then click into the
spreadsheet from the word doc and save this as part of their project - this
has recently started to save over the master copy. Changes made to the master
copy overwrite all individual project documents. I'm sure this never used to
happen! Any ideas on why this is happening??

Thank you!

 

[Guest]

Hi,
Just to explain more I've got Word.doc with a link to Excel.xls - also in
word.doc is a summary table of linked cells from Excel.xls. I could maybe use
a macro to force users to 'save as' when exiting Excel.xls which would
prevent overwriting the master version of Excel.xls every time, BUT the
summary table cells in word.doc would always be linked to the original
Excel.xls.
Any ideas?

 

[Guest]

Its OK - I've redone all the links and have sorted the problem! I was
overlooking the simple fact that I didn't want the icon in the word doc to
link to the original excel spreadsheet - just wanted the summary table to
link to the local spreadsheet.