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?