Hi all,
I'm getting an annoying issue with date formatting with PowerPivot and Excel. When I create a pivot from the PowerPivot workbook itself, the dates are correct in UK format. However, when I access the PowerPivot model as an OLAP cube stored in Sharepoint, the dates appear as US format.
Has anyone come across this issue before? And.. more importantly, does anyone have a solution?
Thanks in advance
I'm getting an annoying issue with date formatting with PowerPivot and Excel. When I create a pivot from the PowerPivot workbook itself, the dates are correct in UK format. However, when I access the PowerPivot model as an OLAP cube stored in Sharepoint, the dates appear as US format.
Has anyone come across this issue before? And.. more importantly, does anyone have a solution?
Thanks in advance