I have a (actually over 100) pivot table spreadsheet that was originally created in Excel 2003 and then later saved in the Excel 2013 format.
The pivot table has its data source in a an MS Access 2003 databases.
I am in the situation now where I must convert my Access 2003 databases to Access 2013, however I have been unsuccessful in getting the pivot tables to change its data source to the new Access 2013 databases.
The error message I encounter is: "you cannot choose a connection that is incompatible with the existing connection".
The existing pivot table has a string of fields stipulated in the Command text box as was typical when creating them in Excel 2003, rather than a single table or query name in the Command text box.
I can however create a new pivot in Excel 2013 that sources its data from Access 2003, then save and close that spreadsheet, then change the data source to Access 2013 no problem.
I have been told that it’s probably due to the fact that the original file was linked on a non-ODBC connection basis and now is incompatible.
However, as I have many pivots forming the basis of many complex reporting templates I am quite (very) keen to find a solution before surrendering to the inevitability of having to recreate all my reports from scratch...
The pivot table has its data source in a an MS Access 2003 databases.
I am in the situation now where I must convert my Access 2003 databases to Access 2013, however I have been unsuccessful in getting the pivot tables to change its data source to the new Access 2013 databases.
The error message I encounter is: "you cannot choose a connection that is incompatible with the existing connection".
The existing pivot table has a string of fields stipulated in the Command text box as was typical when creating them in Excel 2003, rather than a single table or query name in the Command text box.
I can however create a new pivot in Excel 2013 that sources its data from Access 2003, then save and close that spreadsheet, then change the data source to Access 2013 no problem.
I have been told that it’s probably due to the fact that the original file was linked on a non-ODBC connection basis and now is incompatible.
However, as I have many pivots forming the basis of many complex reporting templates I am quite (very) keen to find a solution before surrendering to the inevitability of having to recreate all my reports from scratch...
