98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - Linking cells to word documents
advanced excel ms training - Linking cells to word documents
Resolved · Low Priority · Version Standard
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use Paint Brush to Format More than one CellTo copy a format to many cells or ranges |