Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-03-2016, 05:58 AM
Firooz Firooz is offline Copying linked excel with word files Mac OS X Copying linked excel with word files Office 2016
Novice
Copying linked excel with word files
 
Join Date: Jan 2016
Posts: 3
Firooz is on a distinguished road
Default Copying linked excel with word files

Hi



I have created a report template using microsoft word and I have linked it to excel (various cells in excel) - to make the report writing process easier.

I now want to be able to copy the linked files (word and excel), rename them and have them link in the same way but such that they don't link back to the original files. I'll then want to do this several times, in other words for every report I write I will need to do this.

Is this possible? Any help would be appreciated.

Best
Firooz
Reply With Quote
  #2  
Old 01-04-2016, 02:25 AM
macropod's Avatar
macropod macropod is online now Copying linked excel with word files Windows 7 64bit Copying linked excel with word files Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,859
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

To do that, you'll have to edit the links in the Word document to reflect the changed name and/or path.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-04-2016, 06:39 AM
Firooz Firooz is offline Copying linked excel with word files Mac OS X Copying linked excel with word files Office 2016
Novice
Copying linked excel with word files
 
Join Date: Jan 2016
Posts: 3
Firooz is on a distinguished road
Default

Thanks for that. I saw that you can change the source but then you cannot keep the item the same (i.e. the references to the cells in the spreadsheets). Or is there a way around that.

Cheers
Firooz
Reply With Quote
  #4  
Old 01-04-2016, 04:03 PM
macropod's Avatar
macropod macropod is online now Copying linked excel with word files Windows 7 64bit Copying linked excel with word files Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,859
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you open the document and press Alt-F9, your links will most likely convert to something like:
{ LINK Excel.Sheet.8 "C:\\Users\\Firooz\\Documents\\Workbook.xls" "Sheet1!R1C1:R10C10" \a \f 5 \h }
You can then use Find/Replace to change whatever parts of the path & filename have changed. Note the use of \\ as the path separator. When you're done, press Alt-F9 again to restore the linked display, then Ctrl-A, F9 to update the links.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-05-2016, 12:17 AM
Firooz Firooz is offline Copying linked excel with word files Mac OS X Copying linked excel with word files Office 2016
Novice
Copying linked excel with word files
 
Join Date: Jan 2016
Posts: 3
Firooz is on a distinguished road
Default

Paul! That worked a treat, I didn't think this would be possible.

Appreciate your help - thanks.

Firooz
Reply With Quote
Reply

Tags
linking word and excel

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying linked excel with word files Word linked to Excel Doug Needham Word 5 12-07-2014 01:39 PM
Linked excel cells not updating in word lucky16 Word 0 09-10-2014 07:40 AM
Copying linked excel with word files Movable Word template with linked files and hidden folder Elmobram22 Word 6 11-15-2013 02:11 PM
How to copy linked Excel and Word files and retain links ashleynpeters1 Word 1 05-30-2013 02:25 PM
Pasting linked Excel pie charts into Word Paul-NYS Office 0 07-01-2011 06:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft