Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
import excel 2007 in outlook 2007 | Excel Discussion (Misc queries) | |||
How can you "save as" in excel 2007 (and word 2007)? | Excel Discussion (Misc queries) | |||
Exporting Quickbooks 2007 to Excel 2007 | Excel Worksheet Functions | |||
Problems with my links to an excel 2007 file from a word 2007 file | Links and Linking in Excel |