Link to home
Start Free TrialLog in
Avatar of richeyd
richeydFlag for United States of America

asked on

Excel Paste Special and Microsoft Object Not Working

In Word 2007, when I select a Paste Sepcial and Microsoft Object in order to import and embed an Excel graph into Word 2007, I only see the link path to the Excel document in Word. For example: \\serverx\file\excefilename.xls

But, I need people to see the Excel graphic. I am able to see everything fine in the print preview screen. If I print the graphic appears fine as well. I just can't see the graphic within my normal Word 2007 view.

Any suggestions to make the Excel graphic appear as it should?

Thanks
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Hello,

are you showing the field codes instead of the field? What happens if you hold down Alt and hit F9?

cheers, teylyn
Avatar of richeyd

ASKER

Hi Teylyn,
No, not the field codes, rather the file path. Similar to below:
{Link Excel.Sheet.8 "\\\\\\servername\share\path\excefilename.XLS" "pg.2!RICI:R18C10"\a\p}
When exactly should I be holding Alt F9 and what will that do? Please send me the details.
Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of richeyd

ASKER

Hi Teylyn,
Great! I will test this tomorrow and get back to you.
Thanks
Avatar of richeyd

ASKER

Teylyn,
Alt-F9 worked. But could you just be more specific regarding the menu option to do this before I select your solution as an answer? There is no Tools>Options>View Tab for field codes.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial