Can't clear saved data in Pivottables
 

1. I loaded a pivot table with data from an External Source (SQL Server)
2. I had the Table OPtion save data with table layout. so the data saves
with the table layout.

3. I change the underlying query to look at another data source.
4. I uncheck the save data with table layout option and save the file. close
the file and reopen it, click refresh data.

5.The saved data from the first data source is still in the pivot table with
the new data from the second source.....any ideas?