+ Reply to Thread
Results 1 to 4 of 4

Is it possible to purge a spreadsheet of a pivotable?

  1. #1
    Registered User
    Join Date
    05-22-2020
    Location
    Hayward, California
    MS-Off Ver
    Mac 16.35
    Posts
    2

    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.

    Thanks!

    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
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    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'
    ---
    Hans
    "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

  3. #3
    Registered User
    Join Date
    05-22-2020
    Location
    Hayward, California
    MS-Off Ver
    Mac 16.35
    Posts
    2

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

    So what is the useful information you would like to see? I'm not an expert, so I don't know. But if you tell me, then I can try to provide the information. The only other thing I can add in response to your reply is that nothing is sourced from anything else. There are multiple tables on the same works sheet and same work book. The pivot table is pulling from all of those tables on the same single work sheer.

    Ultimately, I'm trying to remove the pivotable and just leave the original spreadsheet containing is tables. That's it. Is there a way to do that and if so, how please?

    Thanks

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

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

    Hi, if it's just the pivot table then you can select it a delete it. Period, that's all you need to do.
    But, now comes the tricky part.
    You are asking something to persons who have no idea what your workbook looks like, the number of worksheets,, the pivot table (or maybe pivot tables), are these in separate sheets or do they make part of a worksheet that also has a table, are these tables you mention just tables with rows and headers or are they actually Excel tables (ListObjects ?)
    There is a difference because they are treated differently.

    A Pivot table is also an object so you can have a macro that checks out the objects; these objects have names, van be PivotTable 1 or it can be an actual descriptive name you or whoever put this together has given it, the same with tables it can be Table1 Table2 etc, or maybe a more descriptive name.

    So yes, you want an answer and specific ideas, well over concise and precise information.

    You also don't just phone your doctor and tell him 'it hurts when I press here' and he can't see you and you haven't specified 'here'

    Excel is simple and logic but it does answer to rules and syntax rules.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Banded Rows for Pivotable
    By lordfa9 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-26-2017, 01:51 AM
  2. Converting a table to a Pivotable?
    By jeffreyaspence in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-20-2017, 01:08 PM
  3. Pivotable problems
    By QuentinChina in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-25-2013, 03:23 AM
  4. Adjustable Entries in Pivotable
    By johnvhkim in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2012, 06:35 AM
  5. [SOLVED] Using text in pivotable headings
    By Ozwilly in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-05-2012, 08:44 PM
  6. Create a List That is Pivotable
    By Cecil in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2012, 03:06 AM
  7. [SOLVED] pivotable drill down
    By gjpj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2006, 08:35 AM

Tags for this Thread

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