Mac Forum / Applications / Excel / July 2008

In article
<068caa3a-84e4-4db7-a29c-1e4ab8484bd0@f36g2000hsa.googlegroups.com>,

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.

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

On 7/17/08 12:00 PM, in article
068caa3a-84e4-4db7-a29c-1e4ab8484bd0@f36g2000hsa.googlegroups.com, "vfxjohn"