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

Some videos you may like

This Week's Hot Topics