View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
njdavies
 
Posts: n/a
Default 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!)