Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save problem for linked excel spreadsheet
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save problem for linked excel spreadsheet
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? "Meltad" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save problem for linked excel spreadsheet
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. "Meltad" wrote: 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? "Meltad" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
My hyperlink in an excel spreadsheet will not save. | Excel Discussion (Misc queries) | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Can't save Excel using Save button, | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |