The first workbook opened will govern the settings for all subsequent
workbooks.

Do you have a Book1.xlsx in your XLSTART folder? Remove it.

Have you altered the default Excel workbook by creating a new Template
Book.xltx or similar?

Make changes to that Template.


Gord Dibben MS Excel MVP


On Thu, 11 Mar 2010 07:49:01 -0800, M wrote:

When I first open Excel '07, the page defaults to r1c1 reference style and
manual calculations. I change it back to "normal" everyday, but it's so
frustrating! How can I change this permanently? I could do it in earlier
versions of Excel, but haven't found a way here.