| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Datarange of source data
I have a pivot table that is based on a source worksheet. I'm continually
adding lines to the source worksheet and have to keep changing the range in the pivot table. Is there a way to set it permanently to be "all the data in the source worksheet"? (My workaround is setting it at 65000 but I'm not sure whether it's hogging memory by doing that). Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Pivot tables share source data "after the fact" | Excel Worksheet Functions | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
| pivot table in data source order | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Threaded Mode
