Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change range for pivot table on refresh
Hello,
I have a pivot table which looks up a worksheet of data, who's range changes daily (ie some days the data worksheet is 50 rows long, sometimes 500). Is there any way to have the pivot select ALL rows of data without having to change the data range manually every day? Thanks very much, Dan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change range for pivot table on refresh
Use a dynamic range that grows/contracts with your data.
See Debra Dalgeish's site for some nice tips: http://contextures.com/xlNames01.html#Dynamic Dan wrote: Hello, I have a pivot table which looks up a worksheet of data, who's range changes daily (ie some days the data worksheet is 50 rows long, sometimes 500). Is there any way to have the pivot select ALL rows of data without having to change the data range manually every day? Thanks very much, Dan -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change range for pivot table on refresh
you could also define your pivot table data as being from an external data source .. ie the other spreadsheet which contains the data. (second radio button in step 1 of 3 in creating the PT). The additional rows will be automatically included without having to define a named range. regards.. -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=519674 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet protection code conflicts with Pivot Table "auto refresh" | Excel Discussion (Misc queries) | |||
Pivot table Data refresh | Excel Worksheet Functions | |||
Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
Mapping one table based on another table range | Excel Worksheet Functions | |||
Pivot Table Refresh Problems | Excel Discussion (Misc queries) |