How do i enable all 1,00,000+ rows in excel 2007

F

free_ur_mind

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.
 
H

Harald Staff

.... 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel --> Word 4
How can I install Publisher in 365 Enterprise? 1
Cell data entering slow! 0
Integrating information from Word to Excel (not mail merge) 1
Need Help with Macro Security 1
formatting for Rupees 0
Cannot bring rows to Height 1 in Print view 0
how can i ask excel to find "Event" AND NOT "Eventdate" 4

Top