excel charts + word

[vfxjohn]

any suggestion for the best way of using excel charts in other apps
(ie. word)? im running into problems of word changing dates on my
excel charts, and need an alternative solution. anyone out there have
suggestions or tips on how are you dealing with taking charts/graphs
in excel, and including them in various reports?

any tips are appreciated!

thanks,
//john

 

[Carl Witthoft]

any suggestion for the best way of using excel charts in other apps
(ie. word)? im running into problems of word changing dates on my
excel charts, and need an alternative solution. anyone out there have
suggestions or tips on how are you dealing with taking charts/graphs
in excel, and including them in various reports?

any tips are appreciated!

thanks,
//john

Do you want them linked for automatic updates?

I don't think Word can change dates, but if you pasted or linked the
chart in, Word will go "ask" Excel to update any 'live' dates. You will
see the same behavior if you re-open the Excel spreadsheet directly.


Let me submit a standard warning: if you paste or embed an Excel
document in Word, you paste the ENTIRE workbook. Often this means
information you didn't intend to broadcast is available to everyone.
I recommend pasting an image (i.e. Paste Picture, or back in Excel,
CopyAsPIcture) to avoid this.

 

[CyberTaz]

Hi John -

You don't specify what the "changes" are but let me guess - The dates
themselves are being altered by 4 years a day. If that guess is right I'd
further guess that the Excel files being embedded were created by a PC
version of Excel. This is a known issue which under most circumstances is
not a problem.

PC Excel uses the 1900 date system by default whereas Mac Excel uses the
1904 date system. Since the date system setting is workbook-specific it's
irrelevant if you simply move the file from PC to Mac or vice versa.
However, if you copy dates from one & paste into a file that uses the other
date system the pasted dates will be off by 1,462 days.

It appears to have an effect with embedded files as well - apparently the
embedded file doesn't carry the date system preference so the dates are
affected depending on which version of Excel gets launched when you
double-click the object.

More details & suggestions are offered here:

http://support.microsoft.com/kb/180162

If that's not the problem you'll have to be considerably more explicit about
what you mean by "changing dates" as well as what version(s) of Word are
involved, what versions of which operating systems and enough detail to
enable us to help you

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[vfxjohn]

thanks guys. yes... the 4 year thing is whats happening. although,
im using office 08 exclusively. so, not sure why it would be
happening. but thanks again for the info. at least i know the root
cause of the problem going forward.

cheers,
//john