ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do i enable all 1,00,000+ rows in excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/261246-how-do-i-enable-all-1-00-000-rows-excel-2007-a.html)

free_ur_mind

How do i enable all 1,00,000+ rows in excel 2007
 
Excel 2007 as more than 1,00,000 rows, but in our organisation setup i see
only 65536 rows. How do i enable the remaining.

ozgrid.com

How do i enable all 1,00,000+ rows in excel 2007
 
Try to save as Excel 2007 *


--
Regards
Dave Hawley
www.ozgrid.com
"free_ur_mind" wrote in message
...
Excel 2007 as more than 1,00,000 rows, but in our organisation setup i see
only 65536 rows. How do i enable the remaining.



Harald Staff[_2_]

How do i enable all 1,00,000+ rows in excel 2007
 
.... and then close the file, and then reopen it.

You can change the default file format in Office button Excel options,
category Save. This may or may not be reset by your organisation on next
logon.

Best wishes Harald

"ozgrid.com" wrote in message
...
Try to save as Excel 2007 *


--
Regards
Dave Hawley
www.ozgrid.com
"free_ur_mind" wrote in message
...
Excel 2007 as more than 1,00,000 rows, but in our organisation setup i
see
only 65536 rows. How do i enable the remaining.





All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com