Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get more than 65000 rows to display in Excel 2007
I have just recently installed Office 2007 and expected over 1 milliion rows
to be displayed in Excel. For whatever reason, only 65536 rows are being displayed |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get more than 65000 rows to display in Excel 2007
I think that it's controlled by the 'Save files in this format' setting in the Save tab of
the Excel Options dialog box. HTH, Bernie MS Excel MVP "Excel 2007 maximu rows" <Excel 2007 maximu wrote in message ... I have just recently installed Office 2007 and expected over 1 milliion rows to be displayed in Excel. For whatever reason, only 65536 rows are being displayed |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get more than 65000 rows to display in Excel 2007
Thanks Bernie,
I've tried saving as an Excel Workbook (i.e. Excel 2007 with .xlsx extension ) and I still only have 65536 rows available. "Bernie Deitrick" wrote: I think that it's controlled by the 'Save files in this format' setting in the Save tab of the Excel Options dialog box. HTH, Bernie MS Excel MVP "Excel 2007 maximu rows" <Excel 2007 maximu wrote in message ... I have just recently installed Office 2007 and expected over 1 milliion rows to be displayed in Excel. For whatever reason, only 65536 rows are being displayed |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get more than 65000 rows to display in Excel 2007
Did you close that workbook and reopen it?
Excel 2007 maximu rows wrote: Thanks Bernie, I've tried saving as an Excel Workbook (i.e. Excel 2007 with .xlsx extension ) and I still only have 65536 rows available. "Bernie Deitrick" wrote: I think that it's controlled by the 'Save files in this format' setting in the Save tab of the Excel Options dialog box. HTH, Bernie MS Excel MVP "Excel 2007 maximu rows" <Excel 2007 maximu wrote in message ... I have just recently installed Office 2007 and expected over 1 milliion rows to be displayed in Excel. For whatever reason, only 65536 rows are being displayed -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get more than 65000 rows to display in Excel 2007
If the file was from an earlier version, you need to open it, save it as the .xlsx, then close it
and re-open it to get the extra rows. HTH, Bernie MS Excel MVP "Excel 2007 maximu rows" wrote in message ... Thanks Bernie, I've tried saving as an Excel Workbook (i.e. Excel 2007 with .xlsx extension ) and I still only have 65536 rows available. "Bernie Deitrick" wrote: I think that it's controlled by the 'Save files in this format' setting in the Save tab of the Excel Options dialog box. HTH, Bernie MS Excel MVP "Excel 2007 maximu rows" <Excel 2007 maximu wrote in message ... I have just recently installed Office 2007 and expected over 1 milliion rows to be displayed in Excel. For whatever reason, only 65536 rows are being displayed |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get more than 65000 rows to display in Excel 2007
Thanks Dave,
I've re-opened and can now see the full (1mill+) no of rows. Roger "Dave Peterson" wrote: Did you close that workbook and reopen it? Excel 2007 maximu rows wrote: Thanks Bernie, I've tried saving as an Excel Workbook (i.e. Excel 2007 with .xlsx extension ) and I still only have 65536 rows available. "Bernie Deitrick" wrote: I think that it's controlled by the 'Save files in this format' setting in the Save tab of the Excel Options dialog box. HTH, Bernie MS Excel MVP "Excel 2007 maximu rows" <Excel 2007 maximu wrote in message ... I have just recently installed Office 2007 and expected over 1 milliion rows to be displayed in Excel. For whatever reason, only 65536 rows are being displayed -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data contains more than 65000 rows ? | Excel Worksheet Functions | |||
Please help me with microsofts code to convert more than 65000 rows from text to excel | Excel Discussion (Misc queries) | |||
Can I expand Excel workshhet beyond 65000 rows? | Excel Discussion (Misc queries) | |||
How to get more than 65000 rows in and excel spreadsheet | Excel Discussion (Misc queries) | |||
how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions |