+ Reply to Thread
Results 1 to 2 of 2

Is it possible to purge a spreadsheet of a pivotable?

  1. #1
    Registered User
    Join Date
    Hayward, California
    MS-Off Ver
    Mac 16.35

    Is it possible to purge a spreadsheet of a pivotable?

    I have a file I'd like to completely remove the pivotable from...I've tried to just delete the pivotable tab but I just get an error and it doesn't go.
    That's ultimately the main question.

    Aside from that, for some background, this was my first pivotable venture and I built it off of a single spreadsheet with no external source links, but rather multiple tables on the sheet serving as the source links to the main table on which the pivot table sourced from. All was beautiful and I kept expanding the tables with more date and thinking of ways to improve so I made changes and at some point over a few weeks time, suddenly any use of the actual pivotable causes Exel to crash. This is the only file it happens with and only when I mess with the filters on the pivotable. so at this point I want to salvage the original spreadsheet, which if I edit it alone and don't touch the pivotable at all, it seems to save just fine and doesn't cause any crash at all.

    But I'd like to redo the pivotable from scratch at this point to see if it was maybe all my tweaking, so I'm wanting to just purge all the pivotable from the file all together so I can start with a whole new pivotable.

    Hope this makes sense. I loved the pivotable before these issues started popping up and would really like to be able to make use of it again, but can't while I'm stuck with this original pivotable that seems to have become buggy.


    this I Excel for Mac v16 (2016 I believe) and I'm running Mac Mojave 10.14.5

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    The Netherlands
    MS-Off Ver
    Office 2016

    Re: Is it possible to purge a spreadsheet of a pivotable?

    Hi, welcome to the forum.
    I'm no MAC user but your explanation doesn't convey any useful information.
    If you delete the worksheet with the Pivot Table it shouldn't give you errors but since yo're populating it from another table or data range you loose connection to data depending on this pivot table you're removing.
    If there is a graph or other tables linked to this pivot table that you'll have to check those first.
    It's a chain reaction, you work bottom up to avoid 'missing links'
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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