Template is working for Excel2003 but not for Excel2007

Question

I created an Excel worksheet (Book.xlt) under

• C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

with my own setting.

That settings are occurring only for Excel2003(.xls) but not for Excel2007(.xlxs).

How can i make that settings also for Excel 2007

On my PC MS Office 2003 installed and I am opening and modifying MS Office2007 files via File Format converter software.

Answer 1

Try saving your book1.xlt file as a book.xltx (2007 template format) in the same XLSTART folder.

Answer 2

Here are the instructions for customizing starting templates for Excel 2007. Please note that you must create the template in Excel 2007 to ensure full compatibility.