Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Excel 2007 Compabitility Mode (Read 1958 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Excel 2007 Compabitility Mode
23.04.09 at 08:26:37
 
Excel 2007 Compabitility Mode
 
Quote:
Compatibility Mode is a setting for each workbook. It is designed to prevent new or incompatible Excel 2007 features from being saved to a previous Excel file format.

Compatibility Mode is tied to the Excel 97-2003 file format. Whenever a file in this format is opened, the workbook will be in Compatibility Mode. Also, when you save a new file to the Excel 97-2003 format, the next time it is opened the workbook will be in Compatibility Mode.

To exit Compatibility Mode for the workbook you save the file to one of the new file formats and re-open the workbook.

Features Disabled in Compatibility Mode

* The total number of available columns in Excel Restricted to 256 (New Limit: 16k)
* The total number of available rows in Excel Restricted to 64k (New Limit: 1M)
* Max number of arguments per function Restricted to 30 (New Limit: 255)
* Number of levels of nesting in formulas Restricted to 7 (New Limit: 64)
* Formula Length Restricted to 1k characters (New Limit: 8k characters)
* PivotTable Features

 
Source:
http://blogs.msdn.com/excel/archive/2006/08/10/694606.aspx
http://www.internet4classrooms.com/excel_compatibility_mode_07.htm
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1