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 |
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 |
All times are GMT +1. The time now is 05:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com