| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the range of a pivot table data source
Hi
Hope someone can help with this. I want to load a raw data file each month into a template workbook. The size of the raw data changes so I want to change the source range for each pivot table. How do I determine where the raw data ends (rows and columns) and tell the pivottable data source to use the new reference? Any help you can provide would be fantastic. -- Anthony White |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table change data source | Excel Discussion (Misc queries) | |||
| How can I change the source data reference to another pivot table? | Excel Discussion (Misc queries) | |||
| Can't change Pivot Table data source | Excel Worksheet Functions | |||
| Change pivot table source data via macro | Excel Discussion (Misc queries) | |||
| change data source of pivot table | Excel Discussion (Misc queries) | |||
![Tony White[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
