Error in date format of first Pivot table chart

O

OveBonde

Excel 2007:
I have created a workbook with several Pivot tables and corresponding charts
showing trend in various areas of data.

Problem: Even though the date format is "linked to source" and the source is
set for "dd-mm-yyyy tt:mm" (or "dd-mm-åååå tt:mm" in Danish) it still
displays as "mm-dd-yyyy" on the first pivot chart until refreshed with Alt-F5.
The other pivot charts displays date/time as wanted after an update of the
underlying data. All pivot tables and pivot charts are in individual
worksheets.

Removing "linked to source" and setting the date/time format manually
doesn't help on the first pivot chart. Still displays in US-format after a
data update until chart refreshed manually with Alt-F5.

Trying to automate the complete update with macro won't run like Alt-F5.
ActiveSheet.ChartObjects("Chart 1").Activate gives:
(The item with the specified name doesn't exist)

eventhough the macro code was recorded to be like shown.


I believe the above is an error in the Excel Pivot table functionallity.

Anybody else seen this ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Pivot Chart Data Table 1
Refresh Pivot Chart with Table? 0
Formatting pivot chart axis labels for dates 10
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Changing the date format on the date table in a chart 2
format axis number - bug? 4
Change source data in a pivot chart 4

Top