Where are located default preferences for Excel on MacOS?

Beru 0 Reputation points


I want to change some preferences used by default by Excel on MacOS, to be used for any new file.

Especially, I would like to set the calculation mode to automatic, but changing this in the Excel preferences windows (Excel Menu => Preferences) seems to have effect only on the opened workbook, not on all new files (default calculation preferences always reset to manual on my Mac for any new workbook)

How can I change this? Is there a "default template"? a Preferences file? where on the disk?

Many thanks in advance.

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,302 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
442 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Hua-MSFT 27,461 Reputation points

    Hi @Beru

    Please refer to "Customize how Excel starts in Excel for Mac", you can try to create a template ("Book.xltx" or .xltm) for all new workbooks, save this file into Excel folder in Startup folder .

    Hope the information could be helpful to you.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    2 people found this answer helpful.