EXCEL 2007 OPENING IN COMPATIBILITY MODE

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???
 
N

Nick Hodge

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
 

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

Top