Pivot Data Ranges



I have a data sheet that gathers sales data, which is then reported on by a
number of related Pivot tables. As the sales data (by row) increases each
time new orders are taken, the pivot tables data range reference becomes
invalid; resulting in a fair chunk of manual re-working of the data ranges to
get the right reporting.

Last data range was Sales!$A$1:$AM$7370
I capture new sales so rows increase range to Sales!$A$1:$AM$7400
Pivot reports still only refer to Sales!$A$1:$AM$7370 and miss 30 new rows
in reporting.

How can I allow pivot tables to always refer to maximum populated values in
data range, without having to rework each Pivot report?


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