Forum Discussion
Solved
Options won't open in files on Excel
Hi, I'm trying to hide zero values in excel spread sheet. I've selected files>Options but when I do I get taken back to the same worksheet. Nothing is opening and I can't continue to advanced...
- I 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.
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.
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:
Options
Regional Format SettingsChange your regional format settings for Excel for the web
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.
