Speeding up links from Excel to Word

respree

Active Member
Joined
Apr 14, 2003
Messages
258
Hi All:

Does anyone know how to speed up the link updates from Excel to Word.

I've built a model in Excel and want to link it (individual cells) to a Word document. I cut the desired cell from Excel, then Paste Special <Paste Link> <Formatted Text> RTF into Word.

When I initially open the Word file, I'm asked if I want to update. I say "Yes," but it seems awfully slow to update the desired links (in Word). I'm only in the beginning stages of this model, but don't want to waste my time if it's not going to work (nicely). Right now, I've only experimented with about 10 or so links and it takes about 10 seconds. I'm invisioning a couple of hundred links, but don't want it take five minutes for the links to update, as it would render the model virtually useless (by waiting so long). I've also got the Excel file open, in my theory that it might speed up the linking process. I'm not out of memory.

Any ideas if my plan will work, or any ways to speed up the update process?

I know it's like trying to make a dog talk to a cat, but since they're both made by the same company, seems like it should work better than clumsily.

Thanks in advance for any help or ideas.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Forum statistics

Threads
1,141,759
Messages
5,708,361
Members
421,566
Latest member
7Nabisco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top