pivottable

  1. B

    Filtering PivotTable Error HRESULT: 0x80070057 (E_INVALIDARG))

    I've been working on this object for a week now and still cant get it right. All lines are working just fine except for the last line where it should filter the pivot field "Month" into the current month and previous months. I'm trying to have an output of less than or equal to the current...
  2. F

    Can anyone post a guide on how to add pivot functionality to default Excel VBO?

    I need to be able to create a pivot table from a selected range, manipulate the style, filters, data, etc. It would a great help if someone could clarify this for me. Thanks!
  3. N

    Assistance with Excel Pivot Tables

    Hello, I am looking to create a pivot table that calculates max date. Right now I have a code that creates a pivot table, and I can build the dates as columns however I want to know the distinct user and the max date correlated to them. Please find my current code below. Currently it is...
Top