I am using Microsoft 365. Below is my issue:
The name box seems to not display anything when i click the drop down arrow.
Previously it works and now it doesnt. I have named some of my pivot charts and the name of the charts are not displaying in the name box. You may refer to the screen shot below:
1) The snapshot below shows that i have named this pivot chart as Sales Trendline
2) However, when I click the drop down arrow in the Namebox, it appears blank or nothing.
Appreciate if anyone could advise me on this matter.
Thank you!
@AARON_GCZ This is "By Design". The name box drop-down only shows named ranges when you have a cell selected. If you have any object selected, it shows the name of that object, but it does not have any items when you click the drop-down arrow. To see other objects, click the looking-glass icon on the Home tab and choose Selection Pane:
