I'd search for book.xlt, too (using Windows start button|search)

And are you positive that the default workbook format is xl2007?

Abe wrote:

Yes, I mean when I first open Excel (as opposed to opening an existing
workbook), it gives me Book1 [Compatibility Mode]. I looked in C:\Program
Files\Microsoft Office\Office12\XLSTART and this folder is empty. I opened a
new workbook (of course it was in Compatibility Mode), I converted it, and
tried to save it in the XLSTART folder as a file named "Book" but it won't
let me (there's a note that the folder is Read Only). It might just be that
our IT person set it up that way. It's just that to me it seems backward that
I have Excel 2007 and the default new workbook is in Compatibility Mode. It
doesn't take much to convert to 2007 mode, but why should I have to?

"Dave Peterson" wrote:

You mean a new workbook, right?

Did you copy over your book.xlt from your older version of excel?

Look in all your XLStart folders.

Abe wrote:

I have been using Excel 2007 at work for several months now. Just yesterday,
I noticed that when I create a new worksheet, it is in compatibility mode
(65,536 rows, etc).

I don't remember doing anything to set new defaults.

Question 1: Shouldn't a 2007 mode be the default when I create a new
worksheet?
Question 2: How do I make 2007 mode be the default for new worksheets?

Thanks.

--

Dave Peterson


--

Dave Peterson