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

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top