| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
xlsx 2007 display only 65536 rows
hi community
i saw one of my colleague laptop that when he execute his xlsx 2007 and click the Create New workbook, it displays the older version of xls 2003 with 65536 rows and the title bar shows "compatibility mode"...... how can he possible to that?....anybody can enlighten me ??? thanks community -- oldLearner57 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
xlsx 2007 display only 65536 rows
Hi.
As you said it's in compatibility mode. Try to save a document as excel 2007 and that disapear. Cheers, Marco "oldLearner57" wrote: hi community i saw one of my colleague laptop that when he execute his xlsx 2007 and click the Create New workbook, it displays the older version of xls 2003 with 65536 rows and the title bar shows "compatibility mode"...... how can he possible to that?....anybody can enlighten me ??? thanks community -- oldLearner57 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
xlsx 2007 display only 65536 rows
It is a 2003 compatible file, that is limited to 65536 rows. Save it as an
xlsx or xlsm and it will then provide 1M+ rows. -- __________________________________ HTH Bob "oldLearner57" wrote in message ... hi community i saw one of my colleague laptop that when he execute his xlsx 2007 and click the Create New workbook, it displays the older version of xls 2003 with 65536 rows and the title bar shows "compatibility mode"...... how can he possible to that?....anybody can enlighten me ??? thanks community -- oldLearner57 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
xlsx 2007 display only 65536 rows
Like others have said, save as a normal workbook.
But I think you have to close and reopen the workbook to see all the rows. (I think!) oldLearner57 wrote: hi community i saw one of my colleague laptop that when he execute his xlsx 2007 and click the Create New workbook, it displays the older version of xls 2003 with 65536 rows and the title bar shows "compatibility mode"...... how can he possible to that?....anybody can enlighten me ??? thanks community -- oldLearner57 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why Excel 2007 still have the 65536 raw limit? | Excel Discussion (Misc queries) | |||
| Excel 2007 65536 rows-convert | Excel Discussion (Misc queries) | |||
| How to put in over 65536 rows? | Excel Discussion (Misc queries) | |||
| Add more than 65536 rows? | Excel Worksheet Functions | |||
| Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) | |||
Linear Mode
