pivotcaches

  1. O

    dynamic Pivot table range

    Hello Excel Gurus, I am seeking some help writing this code to create multiple pivot tables from - multiple data-sets that are on one worksheet. So my data-set is exported from a website, and it goes from Range "A1:L-infity". My Data-set is dynamic so the range changes when I export it...
  2. M

    Run Time error 13 - Type Mismatch Error - Creating PivotCache

    I am having an issue with my coding for creating a pivotcache - It worked perfectly in another spreadsheet; however, an update was done to the data and the column order changed so I needed to tweak some other code. I never touched the PTCache coding and it works perfectly in the other...
  3. H

    CreatePivotTable fails with Error 1004 on excel 2010

    I have following macro code that works fine on excel 2007 however when I try this on excel 2010 it fails with error 1004 - Application-defined or object-defined error. This seems to be excel version specific but I am not sure what is the cause of this error. Has anyone faced similar issues or...
  4. C

    VBA create pivotcache from another XL file

    This maybe too ambitious. I have 2 workbooks. Workbook A has new data added weekly and Pivot tables refreshed. I would like Workbook B to refresh its Pivot tables from the data in Workbook A. I am newish at VBA, I have been trying to work out how to use the PivotCaches.Create method to Get...
  5. C

    Create multiple pivot caches

    Hi I wan't to create two different pivotcaches from two named ranges. I then want to use those pivot caches in different pivot tables by only change to the loaded cache. Is this possible? Today I have the code below but it needs to much memory. Think it creates lots of different caches. For...
  6. R

    loading pivotcache data into vba array

    Q:how do i load pivotcache data directly into a VBA array? i have a pivot table with over a million rows. the connection to the original external source is inaccessible. however, the contents of the data underneath the pivot table (PivotCache?) will not change. i am aware that i can pull...
  7. R

    Updating PivotTable, why is the sourcedata limited?

    Hi, I'm working in excel 2007 but I appear to have a problem associated with the row limit from excel 2003. Can't figure it out exactly- This code snippet works- it updates the pivottable with the order data from LargeModel, which is an input earlier...

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