Pivot Tables

The UK's most regular instructor-led training courses.
Training information: learn excel in london · Advanced.excel · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Pivot Tables

Johsua has attended:
Excel Advanced course

by - delegate Johsua [3 posts] (2008 Apr 16 Wed, 16:35) Reply

Is it posible to get a formula to run alongside a Pivot table and remain active and useful, even if you alter the pivot table criteria and layout?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	0	FULL
2003	2008 Oct 23 Thu + 24 Fri	Southwark	0	FULL
2003	2008 Oct 30 Thu + 31 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Nov 3 Mon + 4 Tue	Bayswater	4	book now	£475	£485
2003	2008 Nov 17 Mon + 18 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	6	book now	£450	£485
Full Schedule: See all 40 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot Tables

by - trainer Carlos gold contributer [439 posts] (2008 Apr 21 Mon, 09:49) Reply

Hi Joshua

Yes. As long as the formula refers to a cell that does not get hidden or moved with the change of criteria or layout

Hope this helps

Carlos

· Fun Things I've Done With Excel
· Microsoft Excel's Best Kept Secret
· Microsoft Office and the Small Business: Part 1 Excel
· Tools From Advanced Excel Courses: Goal Seek and Solver
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training

Please browse our web site to find out more about
learn excel in london and other Microsoft training courses.