| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unfixing source data range for a pivot table using vba
When I create a pivot table for the first time, the cell references are fixed
in R1C1 format. I would like to have a macro that will enable me to create the same pivot table, and at the same time, update those references to the range of data that would have changed from time to time. Right now I'm stuck when trying to change the source data code in the Visual Basic editor. Currently using MS excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Pivot Table Changes the Source Data Range | Excel Discussion (Misc queries) | |||
| Using cursor keys to select Pivot Table Source Data Range | Excel Discussion (Misc queries) | |||
| Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| Change the range of a pivot table data source | Excel Programming | |||
Threaded Mode
