| 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 |
|
#2
|
|||
|
|||
|
Check out Debra Dalgleish's site:
http://www.contextures.com/xlNames01.html#Dynamic She has instructions on how to create a dynamic range names. Joyce wrote: 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 -- Dave Peterson |
| Reply |
| 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 | |||
Linear Mode
