Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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??? -- Best Regards, FARAZ A. QURESHI |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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/nick...e-formats.aspx -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "FARAZ QURESHI" wrote in message ... 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??? -- Best Regards, FARAZ A. QURESHI |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I turn off compatibility mode in Excel 2007? | Excel Discussion (Misc queries) | |||
Excel 2007, Compatibility Mode, and offline files | Excel Discussion (Misc queries) | |||
Excel 2007 always opens in Compatibility Mode | Excel Discussion (Misc queries) | |||
Office 07 opening older versions in compatibility mode-min/maximiz | Excel Discussion (Misc queries) | |||
Best VBA test for 2007 in Compatibility Mode? | Excel Discussion (Misc queries) |