R1C1 Reference Style

[wtsabo]

I've created a workbook with multiple sheets. When I update multiple sheets at one time, the workbook has switched to R1C1 Referencing on the sheets I'm not viewing. Is there anyway to prevent Excel from making this change? Its driving me crazy.

Thank you
- T

 

[General Ledger]

wtsabo,

I never ran into the issue you are having but this might help. There is a setting in Excel that causes R1C1 referencing. Maybe your setting is not correct.

Navigate to Excel > Options > Formulas > Working with formulas. There is a check box next to R1C1 reference style. Make sure it is unchecked.

Best of luck,

G/L

 

[mikerickson]

How do you know what reference style is being used by a sheet that you aren't viewing?

 

[wtsabo]

How do you know what reference style is being used by a sheet that you aren't viewing?

I know the reference style is not "R1C1" in the sheet I'm viewing, which should be the same for the entire workbook (I thought). Once I make a change to multiple sheets, I select each sheet that changed to R1C1 reference style of the modified formula and fix the R1C1 formula. Why would one sheet be R1C1 and another be default referencing style? I use Excel quiet extensively everyday. I have never selected R1C1 referencing style. It seems strange to me that Excel would modify this setting without the user.