Partager via

Excel 2013 Pivottable Select Multiple Items checkboxes disappear

  • Article

  (Updated Dec 2013)

It has been reported that after applying the latest updates for Excel 2013, the pivottable option to "select multiple items" and basic filtering is behaving strangely for some users. When making that selection and trying to select various items, the checkboxes are "disappearing".

The build this has been reported for is:  15.0.4535.1507 MSO 15.0.4535.1507

This is what you see before making a selection:

Expected

 

 

 

 

 

 

 

After making a selection, the boxes are no longer visible:

Issue

 

WORKAROUND:

Change the Windows Text Size to 100% or 125%. If set to 150% the issue occurs.

Steps:

   Right click on the desktop > Screen Resolution > Make text and other items larger or smaller > Change the size of all items: Smaller - 100% (default)

       OR         

   Control Panel > Display > Change the size of all items:  Smaller - 100% (default)
 

Windows 8.1:

   On 8.1, the steps are similar, but to see the percentages there is an additional option to select:

Right click on the desktop > Screen Resolution > Make text and other items larger or smaller >  select "Let me choose one scaling level for all my displays" > Change the size of all items: Smaller - 100% (default)

        Change the size of all items

 

UPDATE:  This issue has been corrected with the December Cumulative Updates for Office 2013. Updating Excel to this version, should resolve the issue: 15.0.4551.1006 SP2 MSO 15.0.4551.1007

Office 2013 cumulative update for December 2013
https://support.microsoft.com/kb/2912738

What are the most recent updates available for Office? For easier tracking of current updates available for the Office products, the article below is a helpful reference:

Cumulative updates are available from the Microsoft Office team to fix reported problems
https://support.microsoft.com/kb/953878

Comments

  • Anonymous
    January 01, 2003
    Excel 2013 Pivottable Select Multiple Items checkboxes disappear
    thank you

  • Anonymous
    January 01, 2003
    The comment has been removed

  • Anonymous
    October 23, 2013
    The comment has been removed

  • Anonymous
    November 01, 2013
    Hi John, you may also test 125% to avoid going all the way to 100%. Another option is to use the Zoom option available in the Excel application itself. Stay tuned for an update on when a fix is available for this issue.

  • Anonymous
    November 05, 2013
    PLEASE fix this soon.  I am on a Microsoft Surface.  When the display is set to 100%,  it is so tiny it is almost unreadable.  I depend on Pivot Tables for a significant portion of my work.  This is a critical update.

  • Anonymous
    November 26, 2013
    The comment has been removed

  • Anonymous
    November 27, 2013
    The comment has been removed

  • Anonymous
    December 10, 2013
    Same on my surface, really give me a hard time as I need to spend some time on Excel every day. Pls fix it asap.

  • Anonymous
    December 12, 2013
    This issue was raised in October and yet there is no update...ridiculous Microsoft. Just because businesses are on older versions and older OS's isnt an excuse. Am using Surface Pro 2 for my office purposes and wasted 3 hours trying to figure out why am unable to check boxes in pivot.

  • Anonymous
    December 16, 2013
    That you... order has returned to the universe.....

  • Anonymous
    January 21, 2014
    filter multiple items in Pivot reports, http://www.kettic.com/winforms_ui/csharp_guide/pivotgrid_group_report.shtml

  • Anonymous
    February 19, 2014
    I have this problem, even though all updates are applied as far as I can see. As Aubrey said before, on a Surface it's ridiculous! Any idea what might have happened or what I can do?