"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 ta da.... On Mon, Mar 7, 2011 at 5:36 PM, dpk <dpk1...@gmail.com> wrote: how to increse rows in excel 2007 from 65 k to more > >-- ---------------------------------------------------------------------------------- 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 -- ---------------------------------------------------------------------------------- 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
