sick and tired : named ranges KEEP CHANGING BEHIND MY BACK !!!!!

[littlepete]

hello
i'm so angry !!!!
i am always so careful to do one thing at the time, and only after testing up to five times if all works,
i continue with the next item...

i regularly see that my named ranges (for example the column with the name would be rngname) keep changing their range !!!

my first row is always, and nevvvvver changes, row 5 !!! in the picture you'll see that now 137 !!!!! why ??????

how do i solve this ever returning behind my back changing of named ranges that SHOULD KEEP BEING THE SAME !!!!!!!!

sorry for being soooooo angry !

 

[My Aswer Is This]

I suspect someone is inserting or deleting ranges.

 

[ebea]

Start by Lock your row 5 ($N$5), and if it continue to change, look for those using your Excel Sheet

 

[littlepete]

Start by Lock your row 5 ($N$5), and if it continue to change, look for those using your Excel Sheet

done long time ago. only me.

 

[Fluff]

done long time ago.

No it hasn't, your image shows that in most of those names the rows are not locked.