Excel Limit to Named Ranges

Joined
Mar 26, 2018
Messages
1
Reaction score
0
I am sure I have used more than 28 named ranges in the past. For some reason my Excel 2013 worksheet is not displaying the 52 Named Ranges I created. I created one for each week of 2018. It will only list up thru June. Have I turned something on or off by accident? I need to go to Range box and select any one of the 52 weeks that I have named. I am limited to selecting a week only if it falls before June 9th. What's up with that?
 
Welcome to the forum @Tommie :)

That's weird, I'm not sure why that would be the case. If you press Ctrl + F3 it brings up the Name Manager - do they all show in there?
 
Back
Top