Share via

Excel PREFERENCES greyed out

Anonymous
2017-12-05T14:38:35+00:00

I'm running mac os 10.13.1.

I subscribe to Office 365 Home.

Am running Excel 16.9

PREFERENCES under the EXCEL tab is greyed out.

Am having sporadic problems with going back to saved documents where data are missing.

Under FILE -->  OPEN RECENT, most of the files are very old, nothing recent.

JM 

<Thread has been moved to the corresponding category by moderator.>

Microsoft 365 Insider | Excel | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

15 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2017-12-10T16:40:54+00:00

    Something no one mentioned so far - you have to have a workbook open to have Preferences be active. If you open Excel and then close the workbook, you can't change preferences.

    Was this answer helpful?

    40+ people found this answer helpful.
    0 comments
  2. Anonymous
    2017-12-05T15:19:52+00:00

    On your mac, click on finder.

    At the top menu

    Click Go

    Open Library

    If you dont see Library, hold the OPTION key while you click the Go menu.

    Open Preferences.

    Drag com.microsoft.outlook.plist to the desktop.

    Start Outlook to see whether the issue is resolved.

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments
  3. Anonymous
    2017-12-10T20:57:09+00:00

    See if this helps.

    _________

    Disclaimer:

    The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  4. Anonymous
    2017-12-05T14:41:33+00:00

    Have you tried opening Excel in safe mode to see if that works?

    Hold down the CTRL button on your keyboard while opening excel.

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  5. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2017-12-05T14:46:58+00:00

    Would recommend you following -

    1. Update your Office again. Sometimes, in Excel, it requires more than one attempts to make all updates flow.
    2. Go to Tools > Disable all Add-ins and see whether the problem disappears. If yes, enable them one by one and see which one is culprit.
    3. Start your Excel in safe mode. Safe Mode - https://support.apple.com/en-in/HT201262

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments