& 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: