Thank you for reading. I hope this is something simple I am overlooking.
Synopsis: I have a Word doc containing linked charts from a single Excel source. They are docx and xlsx files created in Word and Excel 2010 versions on a PC. I created the charts in Excel, copied and pasted into Word and selected "Keep Source Formatting and Link to Excel" from the clipboard popup. I wish to be able to switch the linked source file for all charts easily using Find and Replace on the Field Codes (feel free to suggest a better way).
Issue: When I try to display the Field Codes for the charts using ALT+F9 or View Field Codes button ({a}), nothing happens to the charts. No Field Codes appear, they just stay charts. I can see other field codes within the document but not for the charts.
I have tried: Using ALT+F9, using the View Field Codes button, checking and un-checking "Show field codes instead of their values" Under File > Options > Advanced.
I appreciate any clues!
Answer
Okay, after much research, I finally just tried a different way of pasting the charts in. Instead of pasting using CTRL+V and using the clipboard popup to select "Keep Source Formatting and Link to Excel", I had to use the Home > Paste... Paste Special... menu option (or ALT+CTRL+V), then choose Paste link: Microsoft Excel Chart Object. I can toggle the field code visibility just fine for objects pasted in this way.
The pasted object seems to behave differently in Word, however. It re-sizes like a picture instead of a chart (stretches text). And the Chart Tools ribbon is not available when it is selected, but it will work for my needs.
Sorry I ended up (sort of) answering myself. Maybe this will help someone else. Thanks!
No comments:
Post a Comment