VBA Pivot Table error “Invalid procedure call or argument”

Multi tool use
Multi tool use








up vote
0
down vote

favorite












Please help me debug this code.
I am getting the following error:




"Invalid procedure call or argument"




Code:



ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
 "MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15).CreatePivotTable TableDestination:="Pivot Sheet!R2C1", TableName:="Compile table", DefaultVersion:=xlPivotTableVersion15





excel vba pivot-table







share|improve this question









New contributor




prajwal rao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.



















  • Try splitting it out into two lines (create the cache, and then the pivot table). For some reason that sometimes fixes things.
    – Tim Williams
    yesterday










  • HI , i split the code as u said by still getting the error
    – prajwal rao
    yesterday










  • Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
    – prajwal rao
    yesterday










  • Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
    – prajwal rao
    yesterday










  • xPivotTableVersion15 ? Is that typo in your original code?
    – Tim Williams
    yesterday















up vote
0
down vote

favorite












Please help me debug this code.
I am getting the following error:




"Invalid procedure call or argument"




Code:



ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
 "MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15).CreatePivotTable TableDestination:="Pivot Sheet!R2C1", TableName:="Compile table", DefaultVersion:=xlPivotTableVersion15





excel vba pivot-table







share|improve this question









New contributor




prajwal rao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.



















  • Try splitting it out into two lines (create the cache, and then the pivot table). For some reason that sometimes fixes things.
    – Tim Williams
    yesterday










  • HI , i split the code as u said by still getting the error
    – prajwal rao
    yesterday










  • Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
    – prajwal rao
    yesterday










  • Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
    – prajwal rao
    yesterday










  • xPivotTableVersion15 ? Is that typo in your original code?
    – Tim Williams
    yesterday













up vote
0
down vote

favorite









up vote
0
down vote

favorite











Please help me debug this code.
I am getting the following error:




"Invalid procedure call or argument"




Code:



ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
 "MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15).CreatePivotTable TableDestination:="Pivot Sheet!R2C1", TableName:="Compile table", DefaultVersion:=xlPivotTableVersion15





excel vba pivot-table







share|improve this question









New contributor




prajwal rao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











Please help me debug this code.
I am getting the following error:




"Invalid procedure call or argument"




Code:



ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
 "MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15).CreatePivotTable TableDestination:="Pivot Sheet!R2C1", TableName:="Compile table", DefaultVersion:=xlPivotTableVersion15





excel vba pivot-table




excel vba pivot-table






share|improve this question









New contributor




prajwal rao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




prajwal rao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited yesterday









Brian Tompsett - 汤莱恩

4,153133699




4,153133699






New contributor




prajwal rao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked yesterday









prajwal rao

1




1




New contributor




prajwal rao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





prajwal rao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






prajwal rao is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











  • Try splitting it out into two lines (create the cache, and then the pivot table). For some reason that sometimes fixes things.
    – Tim Williams
    yesterday










  • HI , i split the code as u said by still getting the error
    – prajwal rao
    yesterday










  • Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
    – prajwal rao
    yesterday










  • Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
    – prajwal rao
    yesterday










  • xPivotTableVersion15 ? Is that typo in your original code?
    – Tim Williams
    yesterday

















  • Try splitting it out into two lines (create the cache, and then the pivot table). For some reason that sometimes fixes things.
    – Tim Williams
    yesterday










  • HI , i split the code as u said by still getting the error
    – prajwal rao
    yesterday










  • Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
    – prajwal rao
    yesterday










  • Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
    – prajwal rao
    yesterday










  • xPivotTableVersion15 ? Is that typo in your original code?
    – Tim Williams
    yesterday
















Try splitting it out into two lines (create the cache, and then the pivot table). For some reason that sometimes fixes things.
– Tim Williams
yesterday




Try splitting it out into two lines (create the cache, and then the pivot table). For some reason that sometimes fixes things.
– Tim Williams
yesterday












HI , i split the code as u said by still getting the error
– prajwal rao
yesterday




HI , i split the code as u said by still getting the error
– prajwal rao
yesterday












Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
– prajwal rao
yesterday




Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
– prajwal rao
yesterday












Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
– prajwal rao
yesterday




Set pca = wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="MainSheet!R1C1:R" & lastRow & "C9", Version:=xPivotTableVersion15) Set pca = PCache.CreatePivotTable(TableDestination:="Pivot Sheet!A1", TableName:="Compiletable", DefaultVersion:=xlPivotTableVersion15)
– prajwal rao
yesterday












xPivotTableVersion15 ? Is that typo in your original code?
– Tim Williams
yesterday





xPivotTableVersion15 ? Is that typo in your original code?
– Tim Williams
yesterday













1 Answer
1






active

oldest

votes

















up vote
0
down vote













xPivotTableVersion15 looks like a typo and



TableDestination:="'Pivot Sheet'!A1"


sheet names with spaces need to be enclosed in single quotes






share|improve this answer




















    Your Answer






    StackExchange.ifUsing("editor", function ()
    StackExchange.using("externalEditor", function ()
    StackExchange.using("snippets", function ()
    StackExchange.snippets.init();
    );
    );
    , "code-snippets");

    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "1"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );






    prajwal rao is a new contributor. Be nice, and check out our Code of Conduct.









     

    draft saved


    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53236367%2fvba-pivot-table-error-invalid-procedure-call-or-argument%23new-answer', 'question_page');

    );

    Post as a guest

















    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    0
    down vote













    xPivotTableVersion15 looks like a typo and



    TableDestination:="'Pivot Sheet'!A1"


    sheet names with spaces need to be enclosed in single quotes






    share|improve this answer
























      up vote
      0
      down vote













      xPivotTableVersion15 looks like a typo and



      TableDestination:="'Pivot Sheet'!A1"


      sheet names with spaces need to be enclosed in single quotes






      share|improve this answer






















        up vote
        0
        down vote










        up vote
        0
        down vote









        xPivotTableVersion15 looks like a typo and



        TableDestination:="'Pivot Sheet'!A1"


        sheet names with spaces need to be enclosed in single quotes






        share|improve this answer












        xPivotTableVersion15 looks like a typo and



        TableDestination:="'Pivot Sheet'!A1"


        sheet names with spaces need to be enclosed in single quotes







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered yesterday









        Tim Williams

        83.3k96481




        83.3k96481




















            prajwal rao is a new contributor. Be nice, and check out our Code of Conduct.









             

            draft saved


            draft discarded


















            prajwal rao is a new contributor. Be nice, and check out our Code of Conduct.












            prajwal rao is a new contributor. Be nice, and check out our Code of Conduct.











            prajwal rao is a new contributor. Be nice, and check out our Code of Conduct.













             


            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53236367%2fvba-pivot-table-error-invalid-procedure-call-or-argument%23new-answer', 'question_page');

            );

            Post as a guest

































































            sHeiB,ONW0IblD,64iIm,mSPjySChuPuUsj,z7C n8Znr5hG,2o41jZEKtIKgO1ZspE61oK e6IqTD6s 4fWK6Qr22h ebAd4CVVxnwt
            -
            xJzg,3KUado

            這個網誌中的熱門文章

            How to read a connectionString WITH PROVIDER in .NET Core?

            圖片
            6 I added .AddJsonFile("Connections.json", optional: true, reloadOnChange: true) in public Startup(IHostingEnvironment env) Connections.json contains: "ConnectionStrings": "DefaultConnection": "Server=(localdb)\mssqllocaldb;Database=DATABASE;Trusted_Connection=True;MultipleActiveResultSets=true", "COR-W81-101": "Data Source=DATASOURCE;Initial Catalog=P61_CAFM_Basic;User Id=USERID;Password=PASSWORD;Persist Security Info=False;MultipleActiveResultSets=False;Packet Size=4096;", "COR-W81-100": "Data Source=DATASOURCE;Initial Catalog=Post_PS;User Id=USERID;Password=PASSWORD;Persist Security Info=False;MultipleActiveResultSets=False;Packet Size=4096;", "MSEDGEWIN10": "Data Source=DATASOURCE; Initial Catalog=COR_Basic; Persist Security Info=False;Integrated Security=true;MultipleActiveResultSets=False;Packet Size=4096;Application Name="COR_Basic"", "server...
            閱讀完整內容

            Spillway

            圖片
            Chute spillway of Llyn Brianne dam in Wales A spillway is a structure used to provide the controlled release of flows from a dam or levee into a downstream area, typically the riverbed of the dammed river itself. In the United Kingdom, they may be known as overflow channels . Spillways ensure that the water does not overflow and damage or destroy the dam. Floodgates and fuse plugs may be designed into spillways to regulate water flow and reservoir level. Such a spillway can be used to regulate downstream flows – by releasing water in small amounts before the reservoir is full, operators can prevent sudden large releases that would happen if the dam were overtopped. Other uses of the term "spillway" include bypasses of dams or outlets of channels used during high water, and outlet channels carved through natural dams such as moraines. Water normally flows over a spillway only during flood periods – when the reservoir cannot hold the excess of water entering the reservoir ove...
            閱讀完整內容

            Americas

            圖片
            For other uses, see America (disambiguation). The Americas Area 42,549,000 km 2 (16,428,000 sq mi) Population 1,001,559,000 (2016 estimate) Population density 23.5389551 23.53896/km 2 ( 60.965614 60.9656/sq mi) GDP (nominal) $24.6 trillion (2016 estimate) GDP per capita $25,229 (2015) [1] HDI 0.736 [2] Demonym American, [3] New Worlder [4] (see usage) Countries 35 Languages Spanish, English, Portuguese, French, Haitian Creole, Quechua, Guaraní, Aymara, Nahuatl, Dutch and many others Time zones UTC−10:00 to UTC Largest cities Largest metropolitan areas Largest cities List 1.São Paulo 2.Lima 3.Mexico City 4.New York City 5.Bogotá 6.Rio de Janeiro 7.Santiago 8.Los Angeles 9.Caracas 10.Buenos Aires CIA political map of the Americas in Lambert azimuthal equal-area projection The Americas (also collectively called America ; French: Amérique , Spanish/Portuguese: América ) comprise the totality of the continents of North and Sou...
            閱讀完整內容