Powerpivot still formats date fields as text when transferring data to Excel Pivot Table in RTM version

Question

Hi - I have just installed the RTM version of powerpivot hoping this issue has been fixed as per the December 2009 (below) posts but it appears it has not. 

http://social.msdn.microsoft.com/Forums/en/sqlkjpowerpivotforexcel/thread/92ae3a04-dc3e-4f30-9e9a-ed05a07b6dab

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=519396&wa=wsignin1.0

I am doing something wrong or has this problem not been addressed yet?

Thanks

Answer 1

Hi,

Can you please double check to make sure the build number is powerpivot is 10.50.1600. As my understanding, this issue is fixed in the RTM version.

Thanks

Hong

Answer 2

I did some tests on RTM build 10.50.1600.1 based on the scenario Marco posted in http://social.msdn.microsoft.com/Forums/en/sqlkjpowerpivotforexcel/thread/92ae3a04-dc3e-4f30-9e9a-ed05a07b6dab

And there appear to have two issues:

1. After copy the Excel date value created with different locale and paste it to PowerPivot, the date column is pasted as Date type, however the display is still in the original locale format. For instance, the Excel date value is entered when the locale is set to Italian, afterwards we change the locale to English, copy the Excel data and Paste it PowerPivot, the date value in PowerPivot is still displayed in Italian format.

In order to see it in English format, you would have to manually select the correct format in the drop down list next to Format in the Formating ribbon under PowerPivot Home tab.

2. Next, if you create PivotTable based on the pasted PowerPivot data, add date column to Row or Column label, the date value is displayed in Italian format. So far I have not found a way to change it.

I have filed bug on both behaviors and we will let you know when we have some update.

Thanks!

Lisa