ExcelBanter - Changing Pivot Table Source from ODBC to .odc.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Changing Pivot Table Source from ODBC to .odc. (https://www.excelbanter.com/excel-discussion-misc-queries/69862-changing-pivot-table-source-odbc-odc.html)

njdavies

Changing Pivot Table Source from ODBC to .odc.

How can I change the External Data Source of a Pivot Table from ODBC (DSN) to
an Office Data Connection (.odc)? (Unfortunately, recreating the Pivot Table
from scratch is not a viable option!)

All times are GMT +1. The time now is 05:07 PM.