Excel 2010 Pivot Table
I am working with an existing Pivot Table in Excel 2010. Is there a way to identify if any of the fields are calculated fields. And also view what is being calculated within that field? Thanks for any info on this.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for the update. I never worked with code like this before but certainly worth trying.
When I call the Subroutine test(), does it output info on the calculated fields in the Pivot Table? Thanks again.
When I call the Subroutine test(), does it output info on the calculated fields in the Pivot Table? Thanks again.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for all the help.
ASKER