If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table Change to US Date Format - Why?
Hi,
I have a set of pivot tables which are being updated by cell the date in cell B1 using the following code: ActiveSheet.PivotTables("PivotTable1").PivotFields ("Invoice Month").CurrentPage = ActiveSheet.Range("B1").Value At last this is working However... the dates are being inserted into the pivot tables as new selections in US date format instead of selecting an existing UK date format from the data choices. I do not understand this as all source data is in UK date format, cell B1 is in UK date format, the pivot field is also in UK date format, so why does this do this? I appreciate someones help!!! |
#2
|
|||
|
|||
Pivot Table Change to US Date Format - Why?
Hi Louise
Try = Format(ActiveSheet.Range("B1").Value,"dd mmm yy") -- Regards Roger Govier Louise wrote: Hi, I have a set of pivot tables which are being updated by cell the date in cell B1 using the following code: ActiveSheet.PivotTables("PivotTable1").PivotFields ("Invoice Month").CurrentPage = ActiveSheet.Range("B1").Value At last this is working However... the dates are being inserted into the pivot tables as new selections in US date format instead of selecting an existing UK date format from the data choices. I do not understand this as all source data is in UK date format, cell B1 is in UK date format, the pivot field is also in UK date format, so why does this do this? I appreciate someones help!!! |
#3
|
|||
|
|||
Pivot Table Change to US Date Format - Why?
Hi Roger,
Thanks for your reply, can I ask where in my code should i place this to get it to work? Kind regards, Louise "Roger Govier" wrote: Hi Louise Try = Format(ActiveSheet.Range("B1").Value,"dd mmm yy") -- Regards Roger Govier Louise wrote: Hi, I have a set of pivot tables which are being updated by cell the date in cell B1 using the following code: ActiveSheet.PivotTables("PivotTable1").PivotFields ("Invoice Month").CurrentPage = ActiveSheet.Range("B1").Value At last this is working However... the dates are being inserted into the pivot tables as new selections in US date format instead of selecting an existing UK date format from the data choices. I do not understand this as all source data is in UK date format, cell B1 is in UK date format, the pivot field is also in UK date format, so why does this do this? I appreciate someones help!!! . |
Thread Tools | |
Display Modes | |
|
|