Error in date format of first Pivot table chart
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
|