advanced excel ms training - linking cells word documents

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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


 

Excel tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips


Server loaded in 0.09 secs.