Pivot Table updating
 

I have created a basic pivot chart, with the source data in another
worksheet.
How can I get it so that updates to the table are reflected in the
chart automatically


--
Pjcan1
------------------------------------------------------------------------
Pjcan1's Profile: http://www.excelforum.com/member.php...o&userid=24277
View this thread: http://www.excelforum.com/showthread...hreadid=379010

You can't make a Pivottable update everytime something happens (unless
you use some VBA-code).
But you can often make the same 'Pivottable layout' by using formulas.

HTH
Ola


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=379010