Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » basic excel training - Pivot tables
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
basic excel training - Pivot tables
Resolved · Low Priority · Version Standard
Reply
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
For upcoming training course dates see: Pricing & availability
RE: Pivot tables
Hi NickThank 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
|
 |
What Does Software Training Mean For Your Firm? On-the-job training definitely has its place in work environments, but in order to move forward and take on competitors your employees may need more guidance, which can be provided by training courses. » Article: Training provider london |
» Forum post: Excel |
If a cell password protected and i need to enter a long name than allow. What's the best to get around it
