pivotables

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

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

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

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

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