Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

basic excel training - pivot tables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic excel training - Pivot tables

basic excel training - Pivot tables

ResolvedVersion Standard

Nick has attended:
Access Introduction course

Pivot tables


I have Microsoft Excel 2003 and on this version you don't appear to be able to draw formulas from a pivot table - i.e. when you create a pivot table you can't draw the data from the pivot table into formulas. The only way I can seem to use / manipulate the data in a pivot table is to copy the pivot table using paste "values" and working from this copy - the problem is everytime you need to update the pivot table you also need to recreate the usable version. Is there a way to use / manipluate the information in a pivot table without having to create a new version by pasting values?

I hope this makes sense!

Cheers
NICK

RE: Pivot tables

Hi Nick

Thank you for your question.

You should be able to create a formula which links a cell outside the pivot table area with a cell in the pivot table by clicking in a blank cell (outside the pivot table) then clicking on the cell in the pivot table you wish to link to. This creates a formula which updates as opposed copying and using paste values which as you point out, doesn't update when the pivot table changes.

See how you get on with this - if there's any further problems please reply to this post again.

thanks
Amanda

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.