pivotables

  1. H

    VBA to Refresh Connections

    Hi, I have code that automatically does a RefreshAll when a worksheet is activated. My issue though is that I need the refreshes to happen in a certain order since pivotables are based off of connection refreshes. I would need all connections to be refreshed first and then all pivotables to be...
  2. B

    slicer connection doesnt show all the pivotables

    hi in my sheet, I have some pivotables which exact common source data but when I create slicer connection I see just the current pivottable. please, how can I fix it? (I ensured it's same source data, I built the slicer again, I tried built slicer to each pivottable and after try connect them)...
  3. R

    Pivots and Charts are broken on reopen

    Pivots and Charts reopen as text: ie cant open the Field List etc... Have no links/cubes etc as stated in other posts on the net. When opening from an email (sent the sheet to someone before closing it the first time) it works but after closing excel and opening it later they are all broken. I...
  4. R

    Pivots and Charts dont work on reopen

    Pivots and Charts reopen as text: ie cant open the Field List etc... Have no links/cubes etc as stated in other posts on the net. When opening from an email (sent the sheet to someone before closing it the first time) it works but after closing excel and opening it later they are all broken. I...
  5. F

    Pivot tables with multiple ranges

    Hi There, i am trying to create a pivot table with multiples ranges, but I am getting the following error when I use a variable for the SourceData. Run-Time error '1004' connot open Pivot Table source file 'Array(Array("Jan.xls'. If I use the range instead of the variable it work. could...

Some videos you may like

This Week's Hot Topics

Top