Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the Max number of records/row allowed in Excel 2007
Okay,
I know that until 2007 excel has a max allowed rows of around 65536. I have read answers here that that cap is no long applied to excel 2007. What is the cap in 2007 or what is the limiting factor now in excel 2007 for the number of records/rows one can have in a worksheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the Max number of records/row allowed in Excel 2007
One million rows (and 16384 columns).
JRM wrote: Okay, I know that until 2007 excel has a max allowed rows of around 65536. I have read answers here that that cap is no long applied to excel 2007. What is the cap in 2007 or what is the limiting factor now in excel 2007 for the number of records/rows one can have in a worksheet. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the Max number of records/row allowed in Excel 2007
And that's one million in computerese <bg: 1,048,576
http://blogs.msdn.com/excel/archive/...23/473185.aspx JRM wrote: Okay, I know that until 2007 excel has a max allowed rows of around 65536. I have read answers here that that cap is no long applied to excel 2007. What is the cap in 2007 or what is the limiting factor now in excel 2007 for the number of records/rows one can have in a worksheet. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the Max number of records/row allowed in Excel 2007
Thanks all.
--JRM "Dave Peterson" wrote: And that's one million in computerese <bg: 1,048,576 http://blogs.msdn.com/excel/archive/...23/473185.aspx JRM wrote: Okay, I know that until 2007 excel has a max allowed rows of around 65536. I have read answers here that that cap is no long applied to excel 2007. What is the cap in 2007 or what is the limiting factor now in excel 2007 for the number of records/rows one can have in a worksheet. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the Max number of records/row allowed in Excel 2007
I saw this post but when I downloaded the trial version of Office 2007 and
did shift, end, down, it still said 65536. How do you display the rows so I can see 100,000 rows, etc.? "JRM" wrote: Thanks all. --JRM "Dave Peterson" wrote: And that's one million in computerese <bg: 1,048,576 http://blogs.msdn.com/excel/archive/...23/473185.aspx JRM wrote: Okay, I know that until 2007 excel has a max allowed rows of around 65536. I have read answers here that that cap is no long applied to excel 2007. What is the cap in 2007 or what is the limiting factor now in excel 2007 for the number of records/rows one can have in a worksheet. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the Max number of records/row allowed in Excel 2007
I haven't seen xl2007 in person, but if you just create a new workbook (not in
xl2003 (or below)) format, what do you see at the bottom? KaySI wrote: I saw this post but when I downloaded the trial version of Office 2007 and did shift, end, down, it still said 65536. How do you display the rows so I can see 100,000 rows, etc.? "JRM" wrote: Thanks all. --JRM "Dave Peterson" wrote: And that's one million in computerese <bg: 1,048,576 http://blogs.msdn.com/excel/archive/...23/473185.aspx JRM wrote: Okay, I know that until 2007 excel has a max allowed rows of around 65536. I have read answers here that that cap is no long applied to excel 2007. What is the cap in 2007 or what is the limiting factor now in excel 2007 for the number of records/rows one can have in a worksheet. -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the Max number of records/row allowed in Excel 2007
You probably opened an existing workbook. That will be opened in compatibility mode.
You can use the Save as.. dialog to save it as a native 2007 workbook.. Then it will have all the properties of an Office 2007 workbook. -- Kind regards, Niek Otten Microsoft MVP - Excel Keep discussions in the newsgroups- no private emails please "KaySI" wrote in message ... |I saw this post but when I downloaded the trial version of Office 2007 and | did shift, end, down, it still said 65536. How do you display the rows so I | can see 100,000 rows, etc.? | | "JRM" wrote: | | Thanks all. | | --JRM | | "Dave Peterson" wrote: | | And that's one million in computerese <bg: 1,048,576 | | http://blogs.msdn.com/excel/archive/...23/473185.aspx | | JRM wrote: | | Okay, | | I know that until 2007 excel has a max allowed rows of around 65536. I have | read answers here that that cap is no long applied to excel 2007. What is | the cap in 2007 or what is the limiting factor now in excel 2007 for the | number of records/rows one can have in a worksheet. | | -- | | Dave Peterson | |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the Max number of records/row allowed in Excel 2007
You are right, I opened up an existing workbook. When I tried a new one, it
had the 1mm + rows. Thanks very much. "Niek Otten" wrote: You probably opened an existing workbook. That will be opened in compatibility mode. You can use the Save as.. dialog to save it as a native 2007 workbook.. Then it will have all the properties of an Office 2007 workbook. -- Kind regards, Niek Otten Microsoft MVP - Excel Keep discussions in the newsgroups- no private emails please "KaySI" wrote in message ... |I saw this post but when I downloaded the trial version of Office 2007 and | did shift, end, down, it still said 65536. How do you display the rows so I | can see 100,000 rows, etc.? | | "JRM" wrote: | | Thanks all. | | --JRM | | "Dave Peterson" wrote: | | And that's one million in computerese <bg: 1,048,576 | | http://blogs.msdn.com/excel/archive/...23/473185.aspx | | JRM wrote: | | Okay, | | I know that until 2007 excel has a max allowed rows of around 65536. I have | read answers here that that cap is no long applied to excel 2007. What is | the cap in 2007 or what is the limiting factor now in excel 2007 for the | number of records/rows one can have in a worksheet. | | -- | | Dave Peterson | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
Excel 2007 PivotTable "arbitrary shape is not allowed when its elements cross a reference dimension" | Excel Discussion (Misc queries) | |||
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
Another Filtering Question for Excel 2007 Experts | New Users to Excel | |||
Excel 2007 Charts Complexity | Charts and Charting in Excel |