| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
updating a pivot table's original data sheet
On Feb 28, 2:18*pm, AB wrote:
If you're on XL2003 - right click into the pivot, goto PivotTableWizard Back. Then select your range. In XL2007/2010 - i think it's one of the Ribbon options when Pivot is active. On Feb 28, 11:44*am, Johnnyboy5 wrote: Hi How do I update the "data" that a pivot table is currently using - if I have made changes to the "main sheet" *eg. added a new column in which I want to use the data for that pivot table. thanks John Brill - was in 2003 - job done thanks. John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range) | Excel Programming | |||
| Dynamically Change a Pivot Table's Data Range | Excel Programming | |||
| Changing a pivot table's data range in Excel 2007 | Excel Worksheet Functions | |||
| Accessing Pivot Table's Data in VBA | Excel Programming | |||
| Accessing Pivot Table's Data | Excel Programming | |||
![Johnnyboy5[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
