excel pivot table - change source data - table doesn't update 1

[shetlandbob]

Hi,

I'm new to pivot tables, basically I'm just trying them out to see what they can do.

Ok I've got a block of data on one sheet and I've figured out how to create the table and play around with settings etc... (I can see why this is a handy tool).

However, when I change the original block of data this is not transferred to the pivot table? I was surprised by this? Do I have some settings wrong, or is this a "feature" or pivot tables?

Thanks,



Robert Cumming

http://www.consultantengineer.co.uk

 

[xlbo]

you must REFRESH the table before the new data will be shown

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[shetlandbob]

Ah ha!! Doh!

Thanks for that (Should really hav been able to figure that out for myself!!)

Cheers

Robert Cumming

http://www.consultantengineer.co.uk