Results 1 to 5 of 5

Application defined or object defined error when creating a Pivot Table

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    59

    Application defined or object defined error when creating a Pivot Table

    I keep running into this error when I try to create a pivot table.

    The debugger highlights the following line:
    ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
            "SCR!A1:AJ65000").CreatePivotTable TableDestination:="[" & wbtemp.Name & "]Statistics!R64C2", _
            TableName:="PivotTable6", DefaultVersion:=xlPivotTableVersion10
    I noticed that when I delete the old pivot table that its supposed to replace, it will work, but otherwise it gives me the error.

    The strange thing is that I don't seem to get this error the other places that I've done this. Replacing the old pivot table. I can't just make it update the table because sometimes, the table doesn't exist yet, which is why I create one.

    Please let me know what the problem could be.

    Thanks
    Last edited by Kaigi; 10-02-2009 at 05:06 PM.

Thread Information

Users Browsing this Thread

There are currently 3 users browsing this thread. (0 members and 3 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1