Automatically update pivot table reference

V

vfxjohn

here's the situation:

ive got a main worksheet with all my raw data
ive got additional worksheets, each with a different pivot table that
references the same data

how do i get my pivot tables to include new data added to the raw
data, without having to modify the reference? i dont care about
having to click 'refresh data' .. i just dont want to be going in and
having to modify the reference always.

caveat: how do i do this without increasing the chances that excel
will crash or not allow me to save?


thanks,
disgruntled excel 2008 user
 

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

Embed the same Excel multiple times 0
Excel 2013 Pivot Data Range formula reference problem 0
Get Pivot data not reading some cells 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Dynamic Pivot - invalid data range 0
pivot table missing rows? 0
How to base a pivot table on another pivot table? 3

Top