Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables
Resolved · Low Priority · Version 2003
Johsua has attended:
Excel Advanced course
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?
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
|
Excel tip:Use shortcut keys to select rows or columnsMost users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that. |
We'll call during UK business hours
Server loaded in 0.08 secs.