change excel sheet defaults
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.
|