Changing Default Excel Sheet Format

**kstoronto** · 06-10-2011, 06:23 PM

We have Excel 2007 at work. The default setting for new sheet that shows when Excel is opened is "Excel 97-2003 Workbook". When I go into Excel options to change the "Save" settings to "Excel Workbook" it changes for this session only. When I go back into Excel the next day, the previous settings or the default settings are back to "Excel 97-2003 Workbook"

How can I change the "Save" settings so that when I go back into Excel, the empty workbook is the new sheet with million rows and not the old one with only 65k rows.

Appreciate your guidance.

KS.

**shg** · 06-10-2011, 06:59 PM

Look in C:\Program Files\Microsoft Office\Office12\XLStart\

If you see a file named Book.xlt, that's the defaul template you're suing for new workbooks. Delete than, and replace it with nothing, or replace it with the workbook to want to use as a template named Book.xltx

Changing Default Excel Sheet Format

LinkBack

Thread Tools

Rate This Thread

Display

Changing Default Excel Sheet Format

Re: Changing Default Excel Sheet Format

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions