Multiple Pivot Tables in a Single Workbook
Posted by Prafulla Matapurkar on February 24, 2001 3:32 AM
I have two lists of roughly 2,000 records and six fields each in a workbook . I have created two pivot tables - one for each list - and then based three more pivot tables on these two.
I want to keep the pivot tables separate from the data.
However, whenever I change the page field item, I get the message "Pivot table saved without underlying data. Please use refresh ...". This happens even when the data source is available in the same workbook.