Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

& not displaying correctly in PivotTable Connections of Slicers

If you right-click on a Slicer and go to PivotTable Connections (Excel 2010 and below) or Report Connections (Excel 2013 and above), then any & in the sheet name will not display correctly.

If you have a single &, the next character will be underlined.
If you have &&, it will show as &.
If you have & at the end, it will show as a period.
If you have two & separated by at least one character, the 1st one will disappear and the 2nd will show as a period.

Other symbols that are allowed in sheet names seem to be fine.

Here is a demo file:
http://www.mediafire.com/view/j37ylma2zgs6uj3/Underline_%26.xlsb

1 vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Kenneth Barber shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base