View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default Changing data source in a pivot

In the pivot table wizard, click the Back button.

"John R" <John wrote in message
...
I have a working pivot table, but need to change the data source to a
different database. Can not find an option to do this, anyone know how?