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

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top