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.

Did you perchance begin your session by opening an XLS file?
Close and open again
Do you have a hidden Personal.XLS file that get opened?
Change it to an XLB file
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Abe" wrote in message
...
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.

Thanks for your reply, Bernard.

I did not open a hidden Personal.XLS. Nor did I open an XLS file at the
beginning of my session. I closed Excel and opened it up again. Still Excel
opened with Book1 [Compatibility Mode].



"Bernard Liengme" wrote:

Did you perchance begin your session by opening an XLS file?
Close and open again
Do you have a hidden Personal.XLS file that get opened?
Change it to an XLB file
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Abe" wrote in message
...
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.

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

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

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

Thanks for your continued interest, Dave.

I searched for "book.xlt" with this result: Nothing found in All Locations
for query "book.xlt"

Again, when I open Excel, what I see is a blank worksheet labeled Book1
[Compatibility Mode] with Sheet1 and Sheet2 (I set mine to have two sheets
when I create a new workbook). Just to be sure, I press End then Down Arrow
and it goes down to row 65536.



"Dave Peterson" wrote:

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

Did you check the default file format yet?

Abe wrote:

Thanks for your continued interest, Dave.

I searched for "book.xlt" with this result: Nothing found in All Locations
for query "book.xlt"

Again, when I open Excel, what I see is a blank worksheet labeled Book1
[Compatibility Mode] with Sheet1 and Sheet2 (I set mine to have two sheets
when I create a new workbook). Just to be sure, I press End then Down Arrow
and it goes down to row 65536.

"Dave Peterson" wrote:

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


--

Dave Peterson