To save the chart and spreadsheet save as. XLC is not supported in Excel or in any newer versions of Excel. Dialog Used in older versions of Excel. Template A pre-formatted spreadsheet created by the user or by Microsoft Excel. The most common are Dynamic Data Exchange: It is very common in financial markets, being used to connect to important financial data services such as Bloomberg and Reuters.
OLE Object Linking and Embedding allows a Windows application to control another to enable it to format or calculate data. This may take on the form of "embedding" where an application uses another to handle a task that it is more suited to, for example a PowerPoint presentation may be embedded in an Excel spreadsheet or vice versa. Excel can accept data in real time through several programming interfaces, which allow it to communicate with many data sources such as Bloomberg and Reuters through addins such as Power Plus Pro.
Although it is easy for users to create such links, programming such links reliably is so difficult that Microsoft, the creators of the system, officially refer to it as "the protocol from hell". Network DDE Extended the protocol to allow spreadsheets on different computers to exchange data.
Starting with Windows Vista, Microsoft no longer supports the facility. RTD although in many ways technically superior to DDE, has been slow to gain acceptance, since it requires non-trivial programming skills, and when first released was neither adequately documented nor supported by the major data vendors. These include opening Excel documents on the web using either ActiveX controls, or plugins like the Adobe Flash Player.
ExcelPackage is another open-source project that provides server-side generation of Microsoft Excel spreadsheets. Excel Services is a current. NET developer tool that can enhance Excel's capabilities. Excel spreadsheets can be accessed from Python with xlrd and openpyxl. Password protection Microsoft Excel protection offers several types of passwords: Password to open a document  Password to modify a document  Password to unprotect worksheet Password to protect workbook Password to protect the sharing workbook  All passwords except password to open a document can be removed instantly regardless of Microsoft Excel version used to create the document.
These types of passwords are used primarily for shared work on a document. Such password-protected documents are not encrypted , and a data sources from a set password is saved in a document's header. The only type of password that can prevent a trespasser from gaining access to a document is password to open a document. The cryptographic strength of this kind of protection depends strongly on the Microsoft Excel version that was used to create the document.
In Microsoft Excel 95 and earlier versions, password to open is converted to a bit key that can be instantly cracked. As regards services which use rainbow tables e. Password-Find , it takes up to several seconds to remove protection.
In addition, password-cracking programs can brute-force attack passwords at a rate of hundreds of thousands of passwords a second, which not only lets them decrypt a document, but also find the original password. Due to the CSP, an Excel file can't be decrypted, and thus the password to open can't be removed, though the brute-force attack speed remains quite high.
The situation changed fundamentally in Excel , where the modern AES algorithm with a key of bits started being used for decryption, and a 50,fold use of the hash function SHA1 reduced the speed of brute-force attacks down to hundreds of passwords per second.
In Excel , the strength of the protection by the default was increased two times due to the use of a ,fold SHA1 to convert a password to a key. Microsoft Excel Viewer Microsoft Excel Viewer was a freeware program for viewing and printing spreadsheet documents created by Excel.
Excel Viewer is similar to Microsoft Word Viewer in functionality. There is not a current version for the Mac. Numeric precision Main article: Numeric precision in Microsoft Excel Excel maintains 15 figures in its numbers, but they are not always accurate: Despite the use of figure precision, Excel can display many more figures up to thirty upon user request. But the displayed figures are not those actually used in its computations, and so, for example, the difference of two numbers may differ from the difference of their displayed values.
Although such departures are usually beyond the 15th decimal, exceptions do occur, especially for very large or very small numbers.
Serious errors can occur if decisions are made based upon automated comparisons of numbers for example, using the Excel If function , as equality of two numbers can be unpredictable. Although this number has a decimal representation that is an infinite string of ones, Excel displays only the leading 15 figures. In the second line, the number one is added to the fraction, and again Excel displays only 15 figures. In the third line, one is subtracted from the sum using Excel.
Because the sum in the second line has only eleven 1's after the decimal, the difference when 1 is subtracted from this displayed value is three 0's followed by a string of eleven 1's. However, the difference reported by Excel in the third line is three 0's followed by a string of thirteen 1's and two extra erroneous digits. This is because Excel calculates with about half a digit more than it displays.
Excel works with a modified version of the IEEE specification. See the main article for details. Besides accuracy in user computations, the question of accuracy in Excel-provided functions may be raised. Particularly in the arena of statistical functions, Excel has been criticized for sacrificing accuracy for speed of calculation. Microsoft has announced some of these issues are addressed in Excel In the case of excessively large results, Excel will return the error warning NUM!
Date range Excel supports dates with years in the range , except that December 31, can be entered as 0 and is displayed as 0-jan Converting a fraction of a day into hours, minutes and days by treating it as a moment on the day January 1, , does not work for a negative fraction. A similar problem occurs when a text happens to be in the form of a floating point notation of a number.
In these cases the original exact text cannot be recovered from the result. This issue has caused a well known problem in the analysis of DNA , for example in bioinformatics. As first reported in ,  genetic scientists found that Excel automatically and incorrectly converts certain gene names into dates.
A follow-up study in  found many peer reviewed scientific journal papers had been affected and that "Of the selected journals, the proportion of published articles with Excel files containing gene lists that are affected by gene name errors is IsText " in VBA , incorrectly returns "false". Filenames Microsoft Excel will not open two documents with the same name and instead will display the following error: You cannot open two documents with the same name, even if the documents are in different folders.
To open the second document, either close the document that is currently open, or rename one of the documents. Microsoft released the first version of Excel for the Macintosh on September 30, , and the first Windows version was 2.
This accomplishment solidified Microsoft as a valid competitor and showed its future of developing GUI software. Microsoft maintained its advantage with regular new releases, every two years or so. Microsoft Windows Excel 2. Versions prior to 2. Excel 2. This included a run-time version of Windows. The magazine stated that the port of the "extraordinary" Macintosh version "shines", with a user interface as good as or better than the original. VBA is a powerful addition to the application and includes a fully featured integrated development environment IDE.
Macro recording can produce VBA code replicating user actions, thus allowing simple automation of regular tasks. The language supports use but not creation of ActiveX COM DLL 's; later versions add support for class modules allowing the use of basic object-oriented programming techniques.
The automation functionality provided by VBA made Excel a target for macro viruses. This caused serious problems until antivirus products began to detect these viruses.
Microsoft belatedly took steps to prevent the misuse by adding the ability to disable macros completely, to enable macros when opening a workbook or to trust all macros signed using a trusted certificate. Versions 5. Internal rewrite to bits. Almost no external changes, but faster and more stable. Excel 97 v8. This was a major upgrade that introduced the paper clip office assistant and featured standard VBA used instead of internal Excel Basic.
It introduced the now-removed Natural Language labels. This version of Excel includes a flight simulator as an Easter Egg. Excel v9. This was a minor upgrade, but introduced an upgrade to the clipboard where it can hold multiple objects at once.
The Office Assistant, whose frequent unsolicited appearance in Excel 97 had annoyed many users, became less intrusive. Excel v Very minor enhancements. Minor enhancements, most significant being the new Tables. This release was a major upgrade from the previous version. Similar to other updated Office products, Excel in used the new Ribbon menu system.
This was different from what users were used to, and was met with mixed reactions. One study reported fairly good acceptance by users except highly experienced users and users of word processing applications with a classical WIMP interface , but was less convinced in terms of efficiency and organisation.
Also added was an improved management of named variables through the Name Manager, and much improved flexibility in formatting graphs, which allow x, y coordinate labeling and lines of arbitrary weight. Several improvements to pivot tables were introduced. To illustrate, the number of rows was now 1,, and columns was 16, ; the far-right column is XFD. Minor enhancements and bit support,  including the following: Multi-threading recalculation MTR for commonly used functions Improved pivot tables.
For the sake of clarity, the parental gate requirement for the Kid's Category is generally not the same as securing parental consent to collect personal data under these privacy statutes. Use Location services in your app only when it is directly relevant to the features and services provided by the app.