Embedding Excel and link to cell adress

[mavve2004]

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!

[macropod]

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

[mavve2004]

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!

[macropod]

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.