Google Sheets - Named ranges automatically sorting to alphabetical?

jimbogarner

Board Regular
Joined
Apr 22, 2010
Messages
102
Hi,

I have some google sheets which link to another system, the third party system picks up the data based on the named ranges in the file, however, they have to be in a particular order otherwise it doesn't pick them up correctly. This never used to be an issue, however, recently any new ones I'm creating Google automatically changes them to alphabetical order - any idea how I stop this as none of my sheets will work anymore;

Example of an old file that works fine;
1672663578242.png


And then the new file I'm creating, the Cube!_Version keeps automatically being sorted alphabetically, in order for to read into our system it needs to swap positions with the WeekYear
1672663630726.png
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
I'm confused - the names in the first picture are also sorted alphabetically, so I don't see what has changed?
 
Upvote 0

Forum statistics

Threads
1,223,315
Messages
6,171,416
Members
452,401
Latest member
Stereonix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top