EXCEL 2007 OPENING IN COMPATIBILITY MODE

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

FARAZ QURESHI

I have just had Excel 2007 installed on my office computer however when I
open the application it shows: "Book1 [Compatibility Mode] on the header and
consists a maximum of 65536 rows & IV columns.

Why???
 
Faraz

Because the spreadsheet you are opening is an earlier version which will
open in compatibility mode and only show the smaller grid. If you take your
existing xls files and save as Excel workbook, they will be upgraded to xlsx
(or xlsm if they have code in them) and after closing and re-opening the
compatibility note will be gone

You may also find a similar phenomenon if your have a personal.xls
workbook. This too will need upgrading to xlsm or xlsb. You should check out
the various file types here

http://excelusergroup.org/blogs/nic.../ribbon-step-by-step-part-1-file-formats.aspx

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk
 
Back
Top