Linking Microsoft Excel Chart Object

Question

When I paste a microsoft excel chart object as a link, I then size this image to 7 inches to fit on my word page.

When I need to relink (not Updated Link which works fine) the object snaps back to its original size. Is there a way that the 7 inches is respected when relinking?

cheers, Erich

Answer 1

Probably the easiest approach is to make the chart the right size in Excel, so you don't have to resize it after pasting it into Word.

Answer 2

1. Quit Word & Excel.
2. Click Start, click Run, type regedit, and then click OK. This opens the Registry Editor.
3. The Registry Editor has a structure reminiscent of a Windows folder structure. Navigate to:

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options

4. With 'Options' selected, right-click and choose New>DWORD value.
5. Type QFE_Boston, then press <Enter>.
6. Right-click QFE_Boston, then click 'Modify'.
7. In the 'Value' data box, type 1, then click OK.
8. Quit Registry Editor.

Answer 3

Sorry Paul, this is way beyond me. Could you walk me through it it layman's terms?

erich

Answer 4

This is a known issue and there is registry key to fix it. Navigate to:

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options]

Add a new DWORD value:

QFE_Boston

Set the new DWORD value to 1