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 |
All times are GMT +1. The time now is 09:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com