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

Watch MrExcel Video

This Week's Hot Topics

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
Top