pivot tables 2013

  1. M

    VBA Pivot Table Errors

    Hi all, I can't seem to figure out why this code is not working to create a pivot table. I'm using Excel 2013 and will be updating to 2019 soon. When I get to the last line of code, I get Runtime Error 5: Invalid Procedure Call or Argument Sub Auto_Pivot() Dim PBook As Workbook Dim PSheet As...
  2. R

    Controlling multiple pivot tables with same slicers when data tables are many-to-many

    I've been a long-time Excel user (25 years) and this one has me stumped. I think I've been staring at it too long or something, but I'll be darned if I can find a way to make it work. I've created a simplified simulation of my data, which consists of the following tables and columns: Revenue...
  3. H

    2013 Excel pivot table cutting off text

    Hi I have pivot tables obtaining data from SQL Server and I just noticed that one of the columns is cut off after 255 characters. This is for 2013 Excel. I have been looking everywhere for a solution to this as this is for work and only seeing for older versions and within cells but not for...
  4. J

    Pivot Table to not Count 0s

    I am using a pivot table to manipulate a large data base that is full of formulas. The formulas are "If" statements set to flag certain items in the data. They return 0 if there isnt a flag. I only want the pivot table to count the cells that are flaged, and not to count the 0 cells. Is this...
  5. D

    Pivot Tables Find difference between 2 columns where fields are not in data set

    Hi I have a data set where the data has a column called Fin Yr and the column is populated as FY15 or FY16 When I show these in a pivot table column view (across) I want to create a new column to show me the difference between the Fin Years Can someone please advise how this is done as a...
  6. G

    Calculated Field not Working in Pivot Table

    Hi, I'm working with a pivot table in 2013 counting dates in various fields. I added several calculated fields to determine conversion rates from one category to the next and all works well. I am attempting to add further calculations, but for some reason the same fields I have been using are...
  7. N

    Making a list of column and row headers if the intersection cell has a Value > 0

    I have a workbook with multiple sheets, with a few hundred rows and about 50 columns. I am trying to make a new spreadsheet with a list of the row and column headers if the intersecting cell has a value >0. Ideally one for each sheet on in a new workbook. This...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top