Office07 - Linking Excel Objects to Word

A

afroat

Hi,

I am working on transitioning my company from Office 2003 to Office
2007. One of my the obstacles right now is linking Excel Objects into
Word. In Office 2003, we could copy an excel range, then paste as
special as an Excel Worksheet Object. Within that excel range, we
would also have a Chart Object. This means that the analysts could
format the cells surrounding the Chart Object in Excel and then link
the whole range (including the chart) into Word.

However, when I link them and then print to PDF, either the Chart
comes through and data/formatting in the surrounding cells, or
alternatively the cells will appear but not the chart
object.Everything is automated which includes the breaking of links
and changing the file source for the link. This means that inserting
the link as a picture or windows metafile won't accomplish the goal
either.

Has anyone else experienced this issue or found a work-around?

Thanks,

Mike
 
B

Bob Buckland ?:-\)

Hi Mike,

You may want to also post in the MS Excel discussion group using the link below.

The ability to link named ranges from Excel to Word was broken by Office 2003 Service Pack 3 (SP3) but shouldn't be affected in most
cases in Word/Excel 2007.

If you're using Office 2007 with SP1 what are the steps you're using and what PDF product and version are you using. Adobe should
be 8.1 with latest updates as a minimum. Do you get the same result using the MS Office 2007 Addin for Save as PDF?

================
Hi,

I am working on transitioning my company from Office 2003 to Office
2007. One of my the obstacles right now is linking Excel Objects into
Word. In Office 2003, we could copy an excel range, then paste as
special as an Excel Worksheet Object. Within that excel range, we
would also have a Chart Object. This means that the analysts could
format the cells surrounding the Chart Object in Excel and then link
the whole range (including the chart) into Word.

However, when I link them and then print to PDF, either the Chart
comes through and data/formatting in the surrounding cells, or
alternatively the cells will appear but not the chart
object.Everything is automated which includes the breaking of links
and changing the file source for the link. This means that inserting
the link as a picture or windows metafile won't accomplish the goal
either.

Has anyone else experienced this issue or found a work-around?

Thanks,

Mike >>
--
Please let us know if this has helped,

Bob Buckland ?:)
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 
Top