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
