hmmm! 40 is a lot .. are they in one spreadsheet or 40?
You can change the data source by double clicking on a single value to
create a new worksheet. Use insertnamedefine and define the data on
the new sheet as (say) "test". use the pivot table wizard back button
to get to step 1 of 3. Select the Microsoft Office list (first radio
button) and set the data range to "test". Complete the Pivot table
steps.
Then do it all again and select the new external datasource. If all
Pivot tables are in one spreadsheet then visit each one and set the
datasource as radio button 3 - Another Pivot Table. Hope it helps...
and I hope someone has a better method.
regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=538453