Forum Discussion
Options won't open in files on Excel
- Jan 29, 2022I had the same problem several people in this thread described. I managed to solve it the following way:
1) Close all open Excel files.
2) Go to `Start` and type `Excel` in the search box.
3) Click on the Excel icon to open the application.
4) When Excel opens and prompts you to select a file, don't open any file (nor create a new one).
5) Go to the bottom left and select `Options`.
6) The `Excel Options` windows will now pop up and you can modify the Excel options.
I hope this helps any other people facing the same issue in the future.
You may have a personal preference to display zero values in a cell, or you may be using a spreadsheet that adheres to a set of format standards that requires you to hide zero values.
There are several ways to display or hide zero values.
examble of One way, find more ways in the Link.
Hide or display all zero values on a worksheet
Click File > Options > Advanced.
Under Display options for this worksheet, select a worksheet, and then do one of the following:
To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.
examble of second way:
Return a blank cell when the value is zero, you can use this formula.
=IF(A2-A3=0,””,A2-A3)
More ways you find in the Link: Display or hide zero values
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
I have the same problem, which your answer does not address.
the primary problem is that >file>options will not open, instead excel reverts to your document instead of the options window.
- Joe_GossAug 02, 2023Copper Contributor
I just recently downloaded microsoft 365 and when I attempted to work on excel macros I found that I could not access options. I on get a sheet with the following:
OptionsRegional Format SettingsChange your regional format settings for Excel for the web- HansVogelaarAug 02, 2023MVP
The File menu in the online (browser) version of Excel has Regional Settings as only item.
The online version has no support for macros: you can neither create them, nor execute them.
The desktop version of Excel for Windows / Mac is included in Microsoft 365. It supports macros.
The Windows version has an extensive File > Options dialog. The Mac equivalent is Excel > Preferences.
- NikolinoDENov 22, 2021Gold Contributor
Please include your Excel version, sample file, and a bit more context to help others answer your question.
Welcome to your Excel discussion space!
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
- Paul1473paulNov 22, 2021Copper Contributor
https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/722750
windows 10 21H1
Excel Version 2110 Build 16.0.14527.20270) 64-bit
Context: when using Excel the >file>options window will not appear when selected, the screen blinks then reverts to the excel document. This works as intended in Word (all part of the same Office suite)
- NikolinoDENov 22, 2021Gold Contributor
I can't tell you why the options don't appear for you either, despite researching, I couldn't find anything in the direction.
But to be on the safe side, do a Windows update to 21H2 beforehand, if the problem persists afterwards, perform an Office repair.
If the problem persists, please let us know, so that maybe someone else, who maybe knows a little more by then, can help.
Thank you for your patience and understanding