Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I get a pivot table to recognize a growing database?
I add new data to the data range weekly. To get the (6) pivot tables which
look at the data to update and include the new lines, I have to go into the wizard and redefine the data range for each pivot. There must be an easier way. |
#2
|
|||
|
|||
Hi Nort
frustration isn't it ... check out "dynamic ranges, naming" at www.contextures.com/tiptech.html for an solution -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Nort" wrote in message ... I add new data to the data range weekly. To get the (6) pivot tables which look at the data to update and include the new lines, I have to go into the wizard and redefine the data range for each pivot. There must be an easier way. |
#3
|
|||
|
|||
Thanx for quick reply. This looks like it.
MN "JulieD" wrote: Hi Nort frustration isn't it ... check out "dynamic ranges, naming" at www.contextures.com/tiptech.html for an solution -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Nort" wrote in message ... I add new data to the data range weekly. To get the (6) pivot tables which look at the data to update and include the new lines, I have to go into the wizard and redefine the data range for each pivot. There must be an easier way. |
#4
|
|||
|
|||
JulieD,
That hit the nail on the head. Why didn't I know about offset() before! What a useful function. Thanks again. MN "JulieD" wrote: Hi Nort frustration isn't it ... check out "dynamic ranges, naming" at www.contextures.com/tiptech.html for an solution -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Nort" wrote in message ... I add new data to the data range weekly. To get the (6) pivot tables which look at the data to update and include the new lines, I have to go into the wizard and redefine the data range for each pivot. There must be an easier way. |
#5
|
|||
|
|||
you're welcome .. .it is definitely a useful function - use it for all my
data validation lists / pivot table sources and Debra's explaination is really helpful too, isn't it? -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Nort" wrote in message ... JulieD, That hit the nail on the head. Why didn't I know about offset() before! What a useful function. Thanks again. MN "JulieD" wrote: Hi Nort frustration isn't it ... check out "dynamic ranges, naming" at www.contextures.com/tiptech.html for an solution -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Nort" wrote in message ... I add new data to the data range weekly. To get the (6) pivot tables which look at the data to update and include the new lines, I have to go into the wizard and redefine the data range for each pivot. There must be an easier way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) |