Excel 2013 Pivottable Select Multiple Items checkboxes disappear
(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:
After making a selection, the boxes are no longer visible:
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)
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