How can I get a pivot table to recognize a growing database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
JulieD,

That hit the nail on the head. Why didn't I know about offset() before!
What a useful function. Thanks again.

MN
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding to an existing Pivot Table 7
Dynamic data ranges in pivot tables 3
Pivot tables - memory issues - please help 2
Pivot Table Wizard Fails to Recognize New Rows of Database 2
Pivot tables - Editing the data source shared by multiple pivot ta 1
Pivot Table Update 3
Pivot Table Ranges 8
How can I change the source data reference to another pivot table? 2

Back
Top