Issue! Dates on Excel charts in PowerPoint keep changing!

  • Thread starter Thread starter baconcow
  • Start date Start date
B

baconcow

I have a PowerPoint presentation that is composed of mainly Excel graphs that
I have copied and pasted from an existing Excel spreadsheet. I am having one
issue with two results that both occur whenever I close the program and then
reopen it or when I save it (also when I print it as an adobe file).

Issues:
- The YEARS along the axis change (i.e. 2007 will become 2003, or sometimes
2011, etc.). The day, however, remains correct. The changes are always the
same, everytime.
- The day keeps shifting one to the left (i.e. Jan 2nd, 2007 will become Jan
1, 2007) for the entire graph. None of the years modify. The changes are
always the same, everytime.

Only certain slides keep doing this, over and over, and in sets (sets
located on the same worksheet). I have tried re-copying them into the
PowerPoint presentation with no fix. I have tried just saving the PowerPoint,
but it doesn't work. I have tried printing it as a PDF, keeps happening. Even
saving it as a 1997-2003 compatible file doesn't help.

I hope somebody has a fix for this or at least a way around it. This is not
the first time that it has happened.

I am using Microsoft Office 2007 with Windows XP Professional with Service
Pack 3 (v.3311). I have Microsoft Office Service Pack 1 installed.

Thanks
 
baconcow said:
- The YEARS along the axis change (i.e. 2007 will become 2003, or
sometimes
2011, etc.). The day, however, remains correct. The changes are always the
same, everytime.
- The day keeps shifting one to the left (i.e. Jan 2nd, 2007 will become
Jan
1, 2007) for the entire graph. None of the years modify. The changes are
always the same, everytime.
Only certain slides keep doing this, over and over, and in sets (sets
located on the same worksheet).
Click to expand...


When I played around with this option I found only one case to see this
behaviour:
- in Excel 1904-date-system is not activated
- I copy and paste the cells into powerpoint with linking
- I activate 1904-date-system in Excel
- I update the presentation with printing, print preview or something else

Are the slides that change so odd are from the same Excel-file than those
that do not change? I wonder if the Excel-option "use 1904 date system"
plays any role in this behaviour.
 
This may be the same issue I ran into during beta with axis numbers changing
to weird stuff, I don't know. But run Diagnostics (Office Button | PPT
Options | Resources) and see if that fixes it. Also make sure you've applied
SP1 for Office 2007.
 
Some of the graphs are from different Excel workbooks, while others are from
the same workbook, but different worksheets. I will investigate which
workbooks they are from and post my results.
 
Back
Top