Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Doubt about pivot table
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
It makes sense and works, but my idea is to use the same cache that is I would like to preserve the formulas in a pivot table to another.
Thank you, Diogo A. Viana Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
doubt | Excel Worksheet Functions | |||
Macro doubt | Excel Discussion (Misc queries) | |||
I have a doubt! | Excel Discussion (Misc queries) | |||
some doubt | Excel Worksheet Functions |