Hi everybody,
Today, i tried to upgrade an excel file from excel 2010 to excel 2013 powerPivot and i faced up a strange behaviour.
The file i upgraded embed a connection to an Excel file as described here . This connection allow me to import data from different excel files with the same structure and it works well in 2010. The name of the connection is "N-1".
After that connection i have created a data model and it works very well in excel 2010.
The trouble appears while upgrading the excel file to 2013 version. After upgrade, all my pivot reports are using the connection "N-1" instead of "ThisWorkbookDataModel" and changing source data is impossible because the option is grayed. When i update my pivot report the data are actualised in PowerPivot (i can see the 150 000 rows count) as is it the case when i actualise data in PowerPivot ?
More over, if i try to create a pivot report directly in excel using external data, i can't access the "ThisWorkbookDataModel" connection whereas this connection exists in the workbook.
And another strange thing is that all my cube formulas are working well with "ThisWorkbookDataModel" as connection name.
So i think that during the upgrade process excel did a mistake between the old "PowerPivot Data" connection and the "N-1" connection i have created just before. He uses the first connection created as connection between Excel and powerPivot but it's a wrong connection.
My question is how can i solve this problem and how to setup connections correctly ? Do you think i will have to create my model and pivot reports again in excel 2013 ?
Tomorrow i'll try to change the connection sting of my "N-1" connection with a valid PowerPivot "ThisWorkbookDataModel" one from another working workbook.
Thank you for you're answer.
Today, i tried to upgrade an excel file from excel 2010 to excel 2013 powerPivot and i faced up a strange behaviour.
The file i upgraded embed a connection to an Excel file as described here . This connection allow me to import data from different excel files with the same structure and it works well in 2010. The name of the connection is "N-1".
After that connection i have created a data model and it works very well in excel 2010.
The trouble appears while upgrading the excel file to 2013 version. After upgrade, all my pivot reports are using the connection "N-1" instead of "ThisWorkbookDataModel" and changing source data is impossible because the option is grayed. When i update my pivot report the data are actualised in PowerPivot (i can see the 150 000 rows count) as is it the case when i actualise data in PowerPivot ?
More over, if i try to create a pivot report directly in excel using external data, i can't access the "ThisWorkbookDataModel" connection whereas this connection exists in the workbook.
And another strange thing is that all my cube formulas are working well with "ThisWorkbookDataModel" as connection name.
So i think that during the upgrade process excel did a mistake between the old "PowerPivot Data" connection and the "N-1" connection i have created just before. He uses the first connection created as connection between Excel and powerPivot but it's a wrong connection.
My question is how can i solve this problem and how to setup connections correctly ? Do you think i will have to create my model and pivot reports again in excel 2013 ?
Tomorrow i'll try to change the connection sting of my "N-1" connection with a valid PowerPivot "ThisWorkbookDataModel" one from another working workbook.
Thank you for you're answer.
