+ Reply to Thread
Results 1 to 4 of 4

Manually delete pivot table drill down sheet

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    18

    Manually delete pivot table drill down sheet

    Hello, I have a pivot table. When I double-click a value it generates the drill down data on a new worksheet. However, it will not let me manually delete the new worksheet. When I right click the worksheet, I do see the Delete menu item but selecting it does not delete the worksheet.

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Manually delete pivot table drill down sheet

    its strange, you can actually delete the drill down sheet. can you post the excel sheet please?
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Registered User
    Join Date
    09-12-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Manually delete pivot table drill down sheet

    When I click the paperclip to attach the file, it does not let me pick a file

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,552

    Re: Manually delete pivot table drill down sheet

    To delete a spreadsheet right click the tab (bottom of screen contains the name of the sheet i.e. Sheet1, Sheet2 etc.).
    To upload a workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window. (As you noted the paper clip icon doesn't work).
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Pivot Table Drill Down
    By Colin12 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-27-2015, 09:09 AM
  2. Pivot Table Drill Down
    By lhughes1983 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-18-2014, 04:44 PM
  3. Pivot table- drill down
    By Bala Daniel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2014, 03:58 PM
  4. Using VBA to format Pivot Table Drill Down and move to a new sheet
    By Billdick7788 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2012, 10:35 AM
  5. Pivot Table drill down
    By andyperiam in forum Excel General
    Replies: 1
    Last Post: 09-18-2009, 01:11 AM
  6. Formating the drill down sheet when double clicking on a pivot table.
    By lowestbass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2008, 11:09 AM
  7. Pivot table drill-down via VB
    By dsuprina in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2007, 12:14 PM

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