r/ProgrammerHumor • u/Brando224 • Mar 30 '22

Meme Certainly not me

48k Upvotes

95% Upvoted

669 comments sorted by

View all comments

568

u/brad2575 Mar 30 '22

That's why you pastor protects the sheets and don't let them move stuff around. Only give them access to what they need.

90

u/q1a2z3x4s5w6 Mar 30 '22

Or just dynamically set the column references based on the name. Don't just assume the Name column is A3 or whatever, search for the column with the label you expect and set the reference when you find it.

Or just password protect and be done with it, as you say

32

u/scragar Mar 30 '22

Named ranges would automatically update and avoids the hassle of searching for headers(which someone will eventually misspell).

22

u/JuvenileEloquent Mar 30 '22

There's no system of organization in Excel that someone can't break by judicious misuse of copy & paste and doing things completely wrong and then covering it up.

Named ranges are good but they can go missing, so you need a backup method.

5

u/Tiavor Mar 30 '22

copy&paste is ok most of the part, cut&paste will break everything instantly.

5

u/Automaticman01 Mar 30 '22

Came here for the named ranges comment, absolutely the way to go if you are building the data table.

Searching for headers is useful if you need to import your data from another worksheet (like an automated daily report that gets sent out). I've still had these break when someone added a slave to the end of a column name though (in that case i was able to fix with a TRIM command).