none
I am getting error "a table cannot overlap with a pivottable report vb.net error" while placing values in Excel based template through VB.net code and in template there is no pivot table at all. RRS feed

  • Question

  • I am getting error "a table cannot overlap with a pivottable report" while placing values in Excel based template through VB.net code and in template there is no pivot table at all.
    • Moved by Terry Xu - MSFT Tuesday, July 10, 2018 8:45 AM Excel Develop Related
    Monday, July 9, 2018 6:12 AM

All replies

  • Hello Saxena,

    VSTO doesn't provide anything for that. 

    You can use a macro recorder available in Excel to get methods and properties required for getting the job done. See Automate tasks with the Macro Recorder  for more information. 

    Also you may find the Finding Overlapping Pivot Tables page helpful. 


    profile for Eugene Astafiev at Stack Overflow, Q&A for professional and enthusiast programmers

    Monday, July 9, 2018 6:52 PM
  • Hello atulsaxena1981,

    Please detail us the related code and the situation in the related workbook/worksheet.

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, July 10, 2018 8:47 AM