ExcelBanter - Changing datasource for pivottables

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

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

- - Changing datasource for pivottables (https://www.excelbanter.com/excel-discussion-misc-queries/164597-changing-datasource-pivottables.html)

PhillyRon

Changing datasource for pivottables

I need to change the datasource for an existing pivottable. The GET DATA box
won't allow you to change the datasource once the pivottable is built. I
tried going through MS query, but it won't allow me to use another database.
What do you do ?

RonLev
Philly

All times are GMT +1. The time now is 11:08 AM.