Spreadsheets created in Microsoft Excel of different versions have a number of properties that make it difficult to open files.
It is worthwhile to understand why the files in Excel do not open.
The most common problems with opening files created byIn Excel, due to the fact that they were created in different versions of the program. If the file was returned in Excel 2007, 2010 and 2013, then it is unlikely to open normally in older versions of the program. The problem can be solved by installing a special patch, created specifically to solve similar compatibility issues. It is called the Microsoft Office Compatibility Pack for Word, Excel and PowerPoint 2007 file formats. Let the name and sounds the number 2007, but the difference between the files created in Excel 2010 and 2013 is not, so this patch is ideal for solving problems with opening files.
There is a free program that by functionality is not inferior to Microsoft Office and in particular to Microsfot Excel. It's called OpenOffice.
If you install this patch for Excel 2003It is possible, you can ask to save this file again from the new format ("xlsx") to the older one ("xls"). In order to do this, in Microsft Excel 2007, 2010 or 201, you must click the "File" button, then click on "Save As", and then choose from the suggested storage formats needed.
Formulas and Editing
Microsoft Excel 2007, 2010 and 2013 have a number ofSignificant advantages over the old versions. First, it is protection against cyclic formulas. This is a logical error, during which the cycle, embedded in the formula, will repeat indefinitely. In the old version of Excel, such a formula could lead to data loss and system hangup in general. More recent versions of the product from Microsoft can block the occurrence of such formulas, such files can not be opened in Excel later versions. If you need to open the file, you will have to ask the creator to delete all the cyclic formulas from the file.
A file created in newer versions of Excel canIs correctly opened not only in the presence of a special patch, but also with the support of all the fonts with which the file was created. Otherwise, they will have to learn their names and download from the official Microsoft website.
It is worth noting that in Microsoft Excel 2007,2010 and 2013 there are such formulas that will not be supported in older versions. Such a file can and will open in them, but not all formulas will work.
Programs that create files for Excel
At the moment, the option to save a file inFormats xls and xlsx offers many programs. Some make it worse, some better. For example, a well-known program FineReader is able to scan files directly to Excel format in fairly good quality. These files will be quietly opened in any version of Microsoft Excel. But there are many other programs that are not able to do it with the same quality. It can be either FineReader analogs or programs that specialize in converting files from format to format. Files created in such programs can not always be opened in Microsoft Excel with good quality.