View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Doubt about pivot table

I had no problem doing so in Excel 2007.

The procedure was:
-- Open both workbooks
-- In the target workbook, specify InsertPivot Table
-- For Select a table or Range, click the Collapse Dialogue button
-- Go to the other workbook and highlight your data table, then click on
Expand Dialogue button
-- Continue normally with the other options

Regards,
Fred

"diogobacon" wrote in message
...

Good afternoon,

I doubt the following staff:

I know that you can create a Pivot Table apart from others in the same
workbook (they share the cache).

But I wonder if it is possible, normally or using VB to create a Pivot
Table starting at one that is in another workbook.

Thank you for your help.

Diogo A. Viana




--
diogobacon