#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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] |
#5
|
|||
|
|||
Paul! That worked a treat, I didn't think this would be possible.
Appreciate your help - thanks. Firooz |
Tags |
linking word and excel |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |