Spreadsheets created in Microsoft Excel different versions, have a number of properties that can be difficult because of which the opening of the files.
It is necessary to understand why the files can not be opened in Excel.
The most common problems with opening files createdin Excel, due to the fact that they were created in various versions. If the file was to pay tribute to Excel 2007, 2010 and 2013, it is unlikely to be opened normally in older versions of the program. The problem can be solved installing a special patch that was created specifically to address these compatibility issues. It is called "Microsoft Office Compatibility Pack for Word, Excel and PowerPoint 2007". Let the title and the figure sounds in 2007, but the difference between the files created in Excel 2010 and 2013 do not, so this patch is ideal for solving problems with opening files.
There is a free program that functionality is not inferior to Microsoft Office, and in particular Microsfot Excel. It's called OpenOffice.
If you install this patch for Excel 2003 is notit is possible, you may be asked to re-save the file in the new format ( «xlsx») to older ( «xls»). To do this, in Microsft Excel 2007, 2010 or 201 you need to click on "File" then click on "Save as" and then select from the proposed conservation required formats.
Formulas and splicing
Microsoft Excel 2007, 2010 and 2013 have a number ofsignificant advantages over the older versions. The first is the protection of the cyclic formulas. This is a logical fallacy, in which the cycle inherent in the formula will be repeated endlessly. In the old version of Excel, such a formula could lead to data loss and system hang at all. More recent versions of Microsoft's products can block the occurrence of similar formulas, such files can not be opened in Excel later. If the file is open is necessary, it will have to ask the creator to remove all the formulas of cyclic file.
The file is created in the new versions of Excel mayproperly opened not only with a special patch, but with the support of all the fonts with which the file is created. Otherwise it is necessary to know their names and download from the official Microsoft website.
It is said that in Microsoft Excel 2007,2010 and 2013, there are formulas that will not be supported in older versions. This file may be opened in them, but the formulas will not work all.
Programs that create files for Excel
At the moment, the option to save the file inxls xlsx formats and offers a variety of programs. Some make it worse, some better. For example, a well-known program FineReader is capable to scan files directly to Excel in fairly good quality. These files will be easily 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 as FineReader analogues and programs specializing in the conversion of files from format to format. Files created in these programs may not always be opened in Microsoft Excel with good quality.