Changing R1C1 Option

jstevens
GoldLounger
Posts: 2628
Joined: 26 Jan 2010, 16:31
Location: Southern California

Changing R1C1 Option

Post by jstevens »

I am encountering the following error when I try to uncheck the R1C1 option in File>Options>Formulas>R1C1 Reference Style. I'm not sure how to resolve it.
EL_104.png
Your thoughts are appreciated.
You do not have the required permissions to view the files attached to this post.
Regards,
John

User avatar
HansV
Administrator
Posts: 78369
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Changing R1C1 Option

Post by HansV »

Could you attach a copy of the workbook?
Best wishes,
Hans

jstevens
GoldLounger
Posts: 2628
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Changing R1C1 Option

Post by jstevens »

Hans,

The challenge seems to have resolved itself. I had turned off the laptop, booted up this morning and was able to uncheck the R1C1 option.

I can not replicate the error at this time.
Regards,
John

User avatar
HansV
Administrator
Posts: 78369
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Changing R1C1 Option

Post by HansV »

OK, all's well that ends well.
Best wishes,
Hans