| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table help
Open both workbooks
Right-click a cell in the pivot table, and choose PivotTable Wizard Click the Back button On the Window menu, choose the new source workbook Select the range you want to use for the pivot table, and click Finish Close the source workbook. ashishprem wrote: Hi, I want some help in pivot table. I have an workbook which contains a pivot table. I want to edit existing the pivot table.I want to change the datasource of the pivot table to some other workbook. I don't know how to do? Shall i edit it or make a new pivot table? please tell me how to proceed? Regards, Ashish -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
Linear Mode
