[Meltad]

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!

[Cindy M.]

Hi ?B?TWVsdGFk?=,

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!

If it's a link, I'm sure this always did happen. Links aren't just one way... If
the user double-clicks a linked Excel object this will open the workbook. The
users must use File/Save As to save a separate copy.

Possibly, something has changed in the folder permissions? If the Excel workbook
is saved in a read-only folder, the user would be forced to "Save As"? Or
perhaps there should be a macro in the workbook to automatically "save as" to a
different location when the user executes the Save command?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

[Meltad]

I see, thanks Cindy. Do you have an example of macro code I could use to do
what you said - force 'save as', or automatically 'save as' on closing/save??

Thank you, Mel

"Cindy M." wrote:

Hi ?B?TWVsdGFk?=,

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!

If it's a link, I'm sure this always did happen. Links aren't just one way... If
the user double-clicks a linked Excel object this will open the workbook. The
users must use File/Save As to save a separate copy.

Possibly, something has changed in the folder permissions? If the Excel workbook
is saved in a read-only folder, the user would be forced to "Save As"? Or
perhaps there should be a macro in the workbook to automatically "save as" to a
different location when the user executes the Save command?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

[Cindy M.]

Hi ?B?TWVsdGFk?=,

Do you have an example of macro code I could use to do
what you said - force 'save as', or automatically 'save as' on closing/save??

Since this would have to be in the linked Excel file, you need to ask about
this in an Excel newsgroup :-) Be sure to explain the full context of what
you're doing, including the version of Office being used.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

[Meltad]

Hi Cindy,

I've just thought of a problem even if I can force 'save as'...
The linked cells pasted into the word document will still be linked to the
original master file even if I save the whole spreadsheet as something else -
can I get round this at all??
I can't have the users creating this linked summary table each time, it will
need to update automatically (or by manually 'update link').
Can I do anything with a template to solve this??

Thanks :-)

"Cindy M." wrote:

Hi ?B?TWVsdGFk?=,

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!

If it's a link, I'm sure this always did happen. Links aren't just one way... If
the user double-clicks a linked Excel object this will open the workbook. The
users must use File/Save As to save a separate copy.

Possibly, something has changed in the folder permissions? If the Excel workbook
is saved in a read-only folder, the user would be forced to "Save As"? Or
perhaps there should be a macro in the workbook to automatically "save as" to a
different location when the user executes the Save command?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

[Meltad]

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 Cindy,

I've just thought of a problem even if I can force 'save as'...
The linked cells pasted into the word document will still be linked to the
original master file even if I save the whole spreadsheet as something else -
can I get round this at all??
I can't have the users creating this linked summary table each time, it will
need to update automatically (or by manually 'update link').
Can I do anything with a template to solve this??

Thanks :-)

"Cindy M." wrote:

Hi ?B?TWVsdGFk?=,

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!

If it's a link, I'm sure this always did happen. Links aren't just one way... If
the user double-clicks a linked Excel object this will open the workbook. The
users must use File/Save As to save a separate copy.

Possibly, something has changed in the folder permissions? If the Excel workbook
is saved in a read-only folder, the user would be forced to "Save As"? Or
perhaps there should be a macro in the workbook to automatically "save as" to a
different location when the user executes the Save command?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)