Excel 2007
 

I just got Excel 2007 installed on my PC. But am very disappointed to see
that there are the same no of rows and columns as were in 2003 ver.

I had heard that the new version has around 10 million rows? Is that not true?

Excel 2007
 

It has 1 million rows.

Pete

On Oct 29, 9:54 am, Malik wrote:
I just got Excel 2007 installed on my PC. But am very disappointed to see
that there are the same no of rows and columns as were in 2003 ver.

I had heard that the new version has around 10 million rows? Is that not true?

Excel 2007
 

Here's something to check if you have 64k rows with a new workbook.
In Excel 2007, click the Office Button (Upper Left)
Click Excel Options on Lower Right
Click Save.
Check the top line "Save files in this format"
Make sure you don't have something like "Excel 97-2003 Workbook."
Perhaps select one of the first two options in the list.
Close, and reopen Excel.

--
Dana DeLouis


"Malik" wrote in message
...
I just got Excel 2007 installed on my PC. But am very disappointed to see
that there are the same no of rows and columns as were in 2003 ver.

I had heard that the new version has around 10 million rows? Is that not
true?

Excel 2007
 

Check to make sure Excel doesn't read [Compatibility Mode] in the
title bar. If it is, you will be limited to 65k rows and 256 columns.


On Oct 29, 5:54 am, Malik wrote:
I just got Excel 2007 installed on my PC. But am very disappointed to see
that there are the same no of rows and columns as were in 2003 ver.

I had heard that the new version has around 10 million rows? Is that not true?

Excel 2007
 

yes really it reads so...how to get rid of it then?
Thanks for locating it.

"iliace" wrote:

Check to make sure Excel doesn't read [Compatibility Mode] in the
title bar. If it is, you will be limited to 65k rows and 256 columns.


On Oct 29, 5:54 am, Malik wrote:
I just got Excel 2007 installed on my PC. But am very disappointed to see
that there are the same no of rows and columns as were in 2003 ver.

I had heard that the new version has around 10 million rows? Is that not true?

Excel 2007
 

Hi Malik

As was suggested earlier in the thread, you need to save the file in an
XL2007 format
Click the round Office buttonFileSave Aschoose the first option if your
file has no macros, or the second option if it does.
Then close the file and re-open.

It will now not be in Compatibility Mode. and you will have access to the
full range of 1,048,576 rows

--
Regards
Roger Govier



"Malik" wrote in message
...
yes really it reads so...how to get rid of it then?
Thanks for locating it.

"iliace" wrote:

Check to make sure Excel doesn't read [Compatibility Mode] in the
title bar. If it is, you will be limited to 65k rows and 256 columns.


On Oct 29, 5:54 am, Malik wrote:
I just got Excel 2007 installed on my PC. But am very disappointed to
see
that there are the same no of rows and columns as were in 2003 ver.

I had heard that the new version has around 10 million rows? Is that
not true?

Excel 2007
 

Thanks so much to all.. esp Roger to make everything crystal clear.
Thanks again guys Finally I have the rows :)

"Roger Govier" wrote:

Hi Malik

As was suggested earlier in the thread, you need to save the file in an
XL2007 format
Click the round Office buttonFileSave Aschoose the first option if your
file has no macros, or the second option if it does.
Then close the file and re-open.

It will now not be in Compatibility Mode. and you will have access to the
full range of 1,048,576 rows

--
Regards
Roger Govier



"Malik" wrote in message
...
yes really it reads so...how to get rid of it then?
Thanks for locating it.

"iliace" wrote:

Check to make sure Excel doesn't read [Compatibility Mode] in the
title bar. If it is, you will be limited to 65k rows and 256 columns.


On Oct 29, 5:54 am, Malik wrote:
I just got Excel 2007 installed on my PC. But am very disappointed to
see
that there are the same no of rows and columns as were in 2003 ver.

I had heard that the new version has around 10 million rows? Is that
not true?