Rachel has attended:
Excel Intermediate course
Linking cells to word documents
I am using a large excel database and linking individual cells to a word documents. I would like to add in rows to the excel database without changing the location of the links in the word documents. Is there a way to do this?
RE: Linking cells to word documents
Hi Rachel
Do you want to add in rows at the end of the document, or in the middle?
Richard
RE: Linking cells to word documents
In the middle, if possible.
RE: Linking cells to word documents
Hi Rachel,
If you insert an entire row, then the rows will move downwards. This will change the location of the links, but they will be the same reletive to the cells that were to the left and right of them orginally.
You could insert a cell, but then you must specify where you want the adjacent cells to be moved. Left or Down. That will allow you to insert a value and not change the links that appear next to it.
I am not entirely sure if that answers your question. Please let me know.
Thanks
Richard
