Sep 06 2021 04:30 PM
I am using Excel 365 (version 2102) and I have somehow set an "R1C1" reference style and want to change it back. However, when I select File...Options, instead of opening the Options dialog box it returns me to the "Home" tab so I can't change the option.
I've searched Microsoft and Googled but I cannot find anyone else who has had a similar problem. Is this a known issue? How do I get out of it?
Sep 07 2021 02:50 AM
SolutionDoes the problem persist after quitting and restarting Excel? After restarting your computer?
Sep 07 2021 04:26 AM
@Hans Vogelaar Thanks for the thought! I had just come back here to post that exiting Excel (many files were open) and restarting it allowed me into the Options menu. I was able to change the setting I was after.
Best Regards!
Sep 07 2021 02:50 AM
SolutionDoes the problem persist after quitting and restarting Excel? After restarting your computer?