Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Meltad Meltad is offline
external usenet poster
 
Posts: 4
Default Problem saving word document with linked excel document

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   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default Problem saving word document with linked excel document

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 :-)

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Meltad Meltad is offline
external usenet poster
 
Posts: 4
Default Problem saving word document with linked excel document

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 :-)


  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default Problem saving word document with linked excel document

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 :-)

  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Meltad Meltad is offline
external usenet poster
 
Posts: 4
Default Problem saving word document with linked excel document

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 :-)




  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Meltad Meltad is offline
external usenet poster
 
Posts: 4
Default Problem saving word document with linked excel document

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 :-)


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word should catalog misspelled words to study. rndthought Microsoft Word Help 39 May 21st 23 02:47 AM
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
How to put graphics on envelopes? Steve Koenig Microsoft Word Help 21 April 29th 23 02:47 AM
Word applies direct format on File open Uriel Microsoft Word Help 16 November 27th 05 07:22 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM


All times are GMT +1. The time now is 07:59 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"