Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - Linking cells to word documents

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

advanced excel ms training - Linking cells to word documents

Resolved · Low Priority · Version Standard

Reply Mon 21 May 2007, 16:14Delegate Rachel said...

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?

For upcoming training course dates see: Pricing & availability

Reply Thu 24 May 2007, 14:33Trainer Richard said...

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

Reply Fri 25 May 2007, 09:31Delegate Rachel said...

RE: Linking cells to word documents

In the middle, if possible.

Reply Tue 29 May 2007, 09:02Trainer Richard said...

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 articles

· How To Add A Second Axis To An Excel Line Chart
· Excel: From The Basic To The Advanced
· How To Use The Page Layout Features In Excel 2007 And Excel 2010
· Creating Top Tables With Excel
· Mastering Page Layout In Excel

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips