pivot table error

  1. C

    Creating a Pivot table Cache

    I am trying to create a basic Pivot Table. I have looked up how to do so on the internet, however, I seem to be running into an error when creating the pivot table Cache. The error I receive is Run-time error '440 Method 'Create' of object 'PivotCaches' failed My code is below. I am new to...
  2. S

    Error in Generating Pivot Table from Macro

    Hi I keep getting errors (either Range error or invalid procedure call error) when trying to run a pivot table using macro. I've attempted to insert a single quote to my table destination but it raises another error i.e. invalid procedure call. I don't know where went wrong?? I'm also thinking...
  3. V

    Pivot table creation error 1004: Pivottable field name is not valid

    Hi all, I am having a peculiar error with excel VBA today. In the code below, are two ways I am using to create a Pivot table. Option 1 is creating the pivot table in the same sheet that the data is in. Option 2 is creating the pivot table in a new sheet. Option 2 does not work. As you can see...
  4. H

    pivot table error but still updates

    <dl class="userinfo_extra" style="margin: 5px 0px; height: auto !important; float: left; width: 180px; "><dd style="margin: 0px; padding: 0px 0px 3px; "> </dd></dl> pivot table error but still updatesI have a workbook with 6 worksheets. One is the source file for my pivot tables, three of them...
  5. T

    Order of Pivot Table items

    I have a list of sales data, including categories and the products within each category. I am trying to specify the order in which the products appear in the pivot table. However, when a product doesn't exist in the data, I get an error. Is there a way to skip over a product if it doesn't exist...
  6. F

    Excel 2007 Pivot Table Update error

    Recently switched from Excel 2003 to 2007. When updating pivot tables, I get error "Cannot open PivotTable sourcefile "drive:path\[filename.xlsx]Detail". The file being opened is listed in the correct path and I have permission to open it. If I have the file in question opened while doing...
  7. T

    Pivot table not displaying data properly

    Hello, I hope someone can help in a quick question. I am using Excel 2007. I have a set of data (pasted below). When i try to create a pivoot table of it, i can not get excel to give it to me in the format i have. I want to see months accross and then each category name one below the...

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