#1
|
|||
|
|||
Embedding Excel and link to cell adress
Hi!
I'm creating some tables in a Excel documnet and then i move those to a Word document. The tables have links to another Excel document. I link to specific cells, e.g. filename.xlsx#'Sheet1'!$C$83. Is there anyway to embed the Excel document (the one the links lead to) and also link to it in the same way as you can when the document is separate? I know how to embed Excel objects but i cannot find out if it's possible to create hyperlinks to it. Anyone know? If that's not possible, does anyone know how to create hyperlinks that does not require the paths do be maintained? e.g. if i have my files in C:\temp and then move all of them to C:\temp2 the links will not work anymore. Anyway of creating them so the documents only have to be in the same folder for it to work? Cheers! |
#2
|
||||
|
||||
Technically, yes, you can insert links to ranges within an embedded Excel object. In practice, though, they tend to be rather fragile. As for what happens when you move the files to a different location, you can edit the links manually or use a macro such as the one attached to: http://windowssecrets.com/forums/sho...External-Files
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for your reply, i'll check on that macro. Would you also be able to explain how i link to cell adress with an emedded object? I cannot find how to do it, when i create a hyperlink it wants me to browse for a file and i cannot find any way of selecting the embedded object.
Cheers! |
#4
|
||||
|
||||
To link to content in an embedded object, open the object and copy the relevant content. Close the object then use Paste Special, with the 'Paste Link' option to paste a link into the parent document.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? | bharathkumarst | Excel | 7 | 10-13-2014 10:25 AM |
How to Link an excel cell to word using Quickparts? | lucky16 | Word | 10 | 10-09-2014 10:20 AM |
An html link from Excel works, but now there is too much extra space in the cell | njweatherdon | Word | 2 | 09-22-2014 09:06 PM |
Embedding vs. Linking an Excel File | mattjac1 | Drawing and Graphics | 1 | 11-01-2013 12:57 AM |
Help with Embedding Excel Tables | atljogger | PowerPoint | 2 | 02-22-2012 09:57 AM |