Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel 2007 using Excel 2003
Issue 1:
If I take a Excel 2007 file saved with a "xlsx" file extension and I manually change the filename extension to "xls", then I open the Excel file using Excel 2003, it displays the following popup message to the user: "This file is not in a recognizable format. - If you know the file is from another probram which is incompatible with Microsoft Office Excel, click Cancel, then open this file in its original application. If you want to open the file later in Microsoft Office Excel, save it in a format that is compatible, such as text format. - If you suspect the file is damaged, click Help for more information about solving the problem. - If you still want to see what text is contained in the file, click OK. Then click Finished in the Text Import Wizard." This popup has an "OK" button and "Cancel" button which the user will need to click on either of the buttons first before the Excel file is opened. How do I stop this popup message from appearing as we do not want any human interactions performed before the Excel file is opened? __________________________________________________ ___________________ Issue 2: When opening Excel 2007 files using Excel 2003, it displays the following popup message to the user: "This file was created in a newer version of Microsoft Excel. The file has been converted to a format you can work with, but the following issues were encountered. The file has been opened in read-only mode to protect the original file. - Some formulas in this workbook contain functions with more arguments than are supported by this version of Excel. Formulas with more than 30 arguments to a function will not be opened and will be converted to #VALUE! errors. - Some formulas in this workbook use more operands than are allowed by this version of Excel. These formulas will not be opened and will be converted to #VALUE! errors." This popup has an "OK" button which the user will need to click on before the Excel file is opened. How do I stop this popup message from appearing as we do not want any human interactions to occur when an Excel file is opened? __________________________________________________ ___________________ Please note that Issue #1 is more important for us so if this can be resolved first, that will be great. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel 2007 using Excel 2003
The easiest way is to save the 2007 document as a 2003 file :) Then all problems go away. If someone send it to you, ask them to save it as a 2003 file Have the same problem at work, some have upgraded to 2007, and some have 2003 still. -- Rock Just a regular user "grace" wrote: Issue 1: If I take a Excel 2007 file saved with a "xlsx" file extension and I manually change the filename extension to "xls", then I open the Excel file using Excel 2003, it displays the following popup message to the user: "This file is not in a recognizable format. - If you know the file is from another probram which is incompatible with Microsoft Office Excel, click Cancel, then open this file in its original application. If you want to open the file later in Microsoft Office Excel, save it in a format that is compatible, such as text format. - If you suspect the file is damaged, click Help for more information about solving the problem. - If you still want to see what text is contained in the file, click OK. Then click Finished in the Text Import Wizard." This popup has an "OK" button and "Cancel" button which the user will need to click on either of the buttons first before the Excel file is opened. How do I stop this popup message from appearing as we do not want any human interactions performed before the Excel file is opened? __________________________________________________ ___________________ Issue 2: When opening Excel 2007 files using Excel 2003, it displays the following popup message to the user: "This file was created in a newer version of Microsoft Excel. The file has been converted to a format you can work with, but the following issues were encountered. The file has been opened in read-only mode to protect the original file. - Some formulas in this workbook contain functions with more arguments than are supported by this version of Excel. Formulas with more than 30 arguments to a function will not be opened and will be converted to #VALUE! errors. - Some formulas in this workbook use more operands than are allowed by this version of Excel. These formulas will not be opened and will be converted to #VALUE! errors." This popup has an "OK" button which the user will need to click on before the Excel file is opened. How do I stop this popup message from appearing as we do not want any human interactions to occur when an Excel file is opened? __________________________________________________ ___________________ Please note that Issue #1 is more important for us so if this can be resolved first, that will be great. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel 2007 using Excel 2003
Users of pre-2007 versions of Office can install a free converter:
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats http://www.microsoft.com/downloads/d...displaylang=en best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "grace" wrote in message ... Issue 1: If I take a Excel 2007 file saved with a "xlsx" file extension and I manually change the filename extension to "xls", then I open the Excel file using Excel 2003, it displays the following popup message to the user: "This file is not in a recognizable format. - If you know the file is from another probram which is incompatible with Microsoft Office Excel, click Cancel, then open this file in its original application. If you want to open the file later in Microsoft Office Excel, save it in a format that is compatible, such as text format. - If you suspect the file is damaged, click Help for more information about solving the problem. - If you still want to see what text is contained in the file, click OK. Then click Finished in the Text Import Wizard." This popup has an "OK" button and "Cancel" button which the user will need to click on either of the buttons first before the Excel file is opened. How do I stop this popup message from appearing as we do not want any human interactions performed before the Excel file is opened? __________________________________________________ ___________________ Issue 2: When opening Excel 2007 files using Excel 2003, it displays the following popup message to the user: "This file was created in a newer version of Microsoft Excel. The file has been converted to a format you can work with, but the following issues were encountered. The file has been opened in read-only mode to protect the original file. - Some formulas in this workbook contain functions with more arguments than are supported by this version of Excel. Formulas with more than 30 arguments to a function will not be opened and will be converted to #VALUE! errors. - Some formulas in this workbook use more operands than are allowed by this version of Excel. These formulas will not be opened and will be converted to #VALUE! errors." This popup has an "OK" button which the user will need to click on before the Excel file is opened. How do I stop this popup message from appearing as we do not want any human interactions to occur when an Excel file is opened? __________________________________________________ ___________________ Please note that Issue #1 is more important for us so if this can be resolved first, that will be great. Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel 2007 using Excel 2003
Yes, that is the easiest way but we need to handle the case when users submit
a 2007 Excel file to us. We are using Excel 2003 on one of the server and we have a batch program on this server that opens the Excel file to perform some tasks. Therefore, we need the ability to open the Excel 2007 file submitted to us using Excel 2003 without receiving any popup messages. If you have any other suggestions to handle this case, that will be great. Thank you. "Rockbear" wrote: The easiest way is to save the 2007 document as a 2003 file :) Then all problems go away. If someone send it to you, ask them to save it as a 2003 file Have the same problem at work, some have upgraded to 2007, and some have 2003 still. -- Rock Just a regular user "grace" wrote: Issue 1: If I take a Excel 2007 file saved with a "xlsx" file extension and I manually change the filename extension to "xls", then I open the Excel file using Excel 2003, it displays the following popup message to the user: "This file is not in a recognizable format. - If you know the file is from another probram which is incompatible with Microsoft Office Excel, click Cancel, then open this file in its original application. If you want to open the file later in Microsoft Office Excel, save it in a format that is compatible, such as text format. - If you suspect the file is damaged, click Help for more information about solving the problem. - If you still want to see what text is contained in the file, click OK. Then click Finished in the Text Import Wizard." This popup has an "OK" button and "Cancel" button which the user will need to click on either of the buttons first before the Excel file is opened. How do I stop this popup message from appearing as we do not want any human interactions performed before the Excel file is opened? __________________________________________________ ___________________ Issue 2: When opening Excel 2007 files using Excel 2003, it displays the following popup message to the user: "This file was created in a newer version of Microsoft Excel. The file has been converted to a format you can work with, but the following issues were encountered. The file has been opened in read-only mode to protect the original file. - Some formulas in this workbook contain functions with more arguments than are supported by this version of Excel. Formulas with more than 30 arguments to a function will not be opened and will be converted to #VALUE! errors. - Some formulas in this workbook use more operands than are allowed by this version of Excel. These formulas will not be opened and will be converted to #VALUE! errors." This popup has an "OK" button which the user will need to click on before the Excel file is opened. How do I stop this popup message from appearing as we do not want any human interactions to occur when an Excel file is opened? __________________________________________________ ___________________ Please note that Issue #1 is more important for us so if this can be resolved first, that will be great. Thank you. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel 2007 using Excel 2003
We have installed the converter and all the High-Priority updates from
Microsoft Update as indicated in the link below. We are still receiving the popup messages indicated in both issue 1 and issue 2 when opening Excel 2007 files using Excel 2003. Do you have any other suggestions? Thank you "Bernard Liengme" wrote: Users of pre-2007 versions of Office can install a free converter: Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats http://www.microsoft.com/downloads/d...displaylang=en best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "grace" wrote in message ... Issue 1: If I take a Excel 2007 file saved with a "xlsx" file extension and I manually change the filename extension to "xls", then I open the Excel file using Excel 2003, it displays the following popup message to the user: "This file is not in a recognizable format. - If you know the file is from another probram which is incompatible with Microsoft Office Excel, click Cancel, then open this file in its original application. If you want to open the file later in Microsoft Office Excel, save it in a format that is compatible, such as text format. - If you suspect the file is damaged, click Help for more information about solving the problem. - If you still want to see what text is contained in the file, click OK. Then click Finished in the Text Import Wizard." This popup has an "OK" button and "Cancel" button which the user will need to click on either of the buttons first before the Excel file is opened. How do I stop this popup message from appearing as we do not want any human interactions performed before the Excel file is opened? __________________________________________________ ___________________ Issue 2: When opening Excel 2007 files using Excel 2003, it displays the following popup message to the user: "This file was created in a newer version of Microsoft Excel. The file has been converted to a format you can work with, but the following issues were encountered. The file has been opened in read-only mode to protect the original file. - Some formulas in this workbook contain functions with more arguments than are supported by this version of Excel. Formulas with more than 30 arguments to a function will not be opened and will be converted to #VALUE! errors. - Some formulas in this workbook use more operands than are allowed by this version of Excel. These formulas will not be opened and will be converted to #VALUE! errors." This popup has an "OK" button which the user will need to click on before the Excel file is opened. How do I stop this popup message from appearing as we do not want any human interactions to occur when an Excel file is opened? __________________________________________________ ___________________ Please note that Issue #1 is more important for us so if this can be resolved first, that will be great. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 errors when opening Excel 2007 document. | Excel Discussion (Misc queries) | |||
Opening Excel 2003 file in Excel 2007: Links do not work | Excel Discussion (Misc queries) | |||
Issue opening 2003 excel files in Excel 2007 | Excel Discussion (Misc queries) | |||
Opening Excel 2007 file with Excel Viewer 2003 | Excel Discussion (Misc queries) | |||
Excel 2007, why is it slow opening files created in Excel 2003? | Excel Discussion (Misc queries) |