I figured it out, They hide the switch in a defferent places for each copy of Excel. Some people perfer numbers to letters on the columns and when that person sends you a file and you open it' it changes every workbook on your computer and every other computer in your group. And to change it back, one workbook at a time you find that switch which is not set to R1C1 and you have set it to R1C1 and save the change and the go back and unselect it and save the changes. Just 30 workbooks to go.
You would think that if was going to change something outomaticly, they would change all effected formulas too.
I did read that some people working with formula need to know how many columns they are moving over, I never would have thought about changing the program, I've always just used auto fill and put a row of numbers under the labels and split the screen to keep it at the top.