Yes you are right For some reason, my XL default format = "*.xls"
Thank you Mr Schreiner. [image: XL default format.GIF] On Tue, Mar 15, 2011 at 7:26 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > "Technically" if your Excel 2007 Default Save format is "Excel97-2003" > format, > then what you said is true: a new workbook opens in "compatibility mode". > > If your default format is .xlsx, .xlsm, or .xlsb > then a new workbook will have 1,048,576 rows and 16,384 columns > (even before saving!) > > Paul > > *From:* STDEV(i) <setiyowati.d...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Tue, March 15, 2011 3:31:24 AM > *Subject:* Re: $$Excel-Macros$$ how to increse rows in excel 2007 from 65 > k to more > if you open a blank workbook in excell 2007 > the workbook is in compatibility mode > save your workbook in *.XLSX format > close your workbook, and open again > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
<<XL default format.GIF>>
