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...

8 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...

8 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...

8 years ago
Reply
8 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...

8 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...

9 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...

9 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 ...

9 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...

9 years ago
Page 2 / 2