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 ?
--
Best regards
Ove B