Forum

John Michaloudis
@johnmika
Eminent Member
Joined: Jan 24, 2014
Topics: 0 / Replies: 24
Reply
RE: Pivot table cache

Hello Hans, Here is a tutorial on how to view and delete Pivot Table caches: Here is some more material on this subject:and you can also buy an a...

9 years ago
Reply
RE: Saving Pivot Chart Template

Hello Hans, In Excel 2013 & 2016 you need to Right Click on the chart and select Save as a Template. Please refer to video lecture to s...

9 years ago
Reply
RE: Calculated Field result in 0

Hey Bill, You need to change the X in your NEW and RW fields to 1. This will allow the PT to sum 1s rather than Xs, which it cannot do. I hav...

10 years ago
Reply
10 years ago
Reply
RE: Calculated Field result in 0

Hey Bill, Can you please attached your workbook so I can dig into it and see where the issues lies. It may be a simple thing but I want to see t...

10 years ago
Reply
RE: Conditional formatting a text row label including all of the values associated to the text

Hello Theresa, To highlight the entire row you will need to add a Conditional Format based on a Formula. The formula will look like this: =$A...

10 years ago
Reply
RE: Excel 2016 Paste Pivot Chart as Link

Hi Sonia, I have tested the Paste Special Linked Picture and it works in Excel 2016. You need to make sure NOT TO COPY the Pivot Chart. You n...

10 years ago
Reply
RE: Excel 2016 Paste Pivot Chart as Link

Hello Sonia, I will be glad to help you out 🙂 You need to select the cell that the Pivot Chart is located in and press CTRL+C. It seems that ...

10 years ago
Reply
RE: 12-month Running Total

Hello Tracy, You can certainly do this but you will need to add an OFFSET formula outside the Pivot Table to get this moving Running Total. I ha...

10 years ago
Page 2 / 2
0