Excel Limit to Named Ranges

T

Tommie

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?
 
Becky

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximum Named Ranges in Excel? 0
Validation list from Named Ranges 5
Code to Reset Named Ranges when copy/paste to new file 2
Add Named Range 1
named ranges 2
Limit to number of named ranges before Excel starts messing things up? 3
Named Ranges vs. Constant Addresses, sheet protection, Guidance. 1
Is 300,000 Named Ranges going to cause problems? 3

Top