I created charts at home in Excel and used them in a Word document. In the Word file, I had captions for these charts and crosslinked to references in the body of the Word document's text. I saved these files to my thumb drive, took them to work, did some editing and when I went to refresh, I got an invalid link message. Went to Edit Links and removed the ones in the list. The crosslinks that referenced the figures went away, but it still gave me linking error when trying to refresh, even when I reestablished new crosslinks at work.

Is there a way to paste charts into a standalone Word documents where there is no link to the Excel file, so that when I make my crosslinks, there is no referencing problems when I move the Word file to a different location?

Hi derohanes,

When pasting, use Paste Special and make sure the 'Paste Link' option is not active.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I don't see a "paste special" when pasting into a Word doc. Also, Where is the control for "Paste Link?"

Hi derohanes,

On the Paste icon on the Home tab, there's a small down arrow at the bottom. Click that and you'll see the 'Paste Special' option. The 'Paste Link' option is on a radio button on the dialogue box that clicking on the 'Paste Special' option displays.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]