JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,676
- Office Version
- 365
- Platform
- Windows
For some reason, none of the names of my named ranges are showing up in the Name Box. I'm pretty sure they were yesterday. This is true for every sheet in one workbook. In sheets in other workbooks, they do show up.
Is there some setting that suppresses the names being displayed?
This is a workbook I downloaded from this Bureau of Labor Statistics page:
May 2021 National Occupational Employment and Wage Estimates
I downloaded it again. The newly downloaded version does not have this problem, so I am assuming it's something I did, but I have no idea what.
I found another thread here with a similar topic, but those were all dynamic ranges. These are not. Most of them are a single cell. One or two are multiple cells.
Is there some setting that suppresses the names being displayed?
This is a workbook I downloaded from this Bureau of Labor Statistics page:
May 2021 National Occupational Employment and Wage Estimates
I downloaded it again. The newly downloaded version does not have this problem, so I am assuming it's something I did, but I have no idea what.
I found another thread here with a similar topic, but those were all dynamic ranges. These are not. Most of them are a single cell. One or two are multiple cells.