SOLVED

File Options button returns to "Home" Tab

Copper Contributor

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?

2 Replies
best response confirmed by DBMason21 (Copper Contributor)
Solution

@DBMason21 

Does the problem persist after quitting and restarting Excel? After restarting your computer?

@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!

1 best response

Accepted Solutions
best response confirmed by DBMason21 (Copper Contributor)
Solution

@DBMason21 

Does the problem persist after quitting and restarting Excel? After restarting your computer?

View solution in original post