XL97: Error When You Display Form Created by Web Form Wizard

Last reviewed: January 15, 1998
Article ID: Q161795
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

When you use an Internet browser to view a form that is created by the Web Form Wizard, you may receive the following error message:

   <File name>: file format is not valid

where <File name> is the name of the form. When this behavior occurs, your only option is to click OK.

CAUSE

This behavior may occur if Microsoft Excel 97 is not installed on the computer. To use your Internet browser to display a form that is created by the Microsoft Excel 97 Web Form Wizard, Microsoft Excel 97 must be installed on your computer.

The form created by the Web Form Wizard is a Microsoft Excel 97 workbook. When you use a Web browser to view this form, Microsoft Excel 97 must open the workbook in order for the browser to display the form.

RESOLUTION

To resolve this behavior, install Microsoft Excel 97 on your computer.

MORE INFORMATION

Requesting and gathering information over the Internet requires the use of forms. In addition, you must have some knowledge of the server, database storage, and computer programming.

Because you can use a Microsoft Excel worksheet to simulate a form, you can use Microsoft Excel 97 as an engine to generate a form for the Web.

When others visit your Web site and make a request for the Microsoft Excel 97 form, the form is downloaded to the client, and Microsoft Excel 97 is started. When the user completes the form and clicks Submit Info, Microsoft Excel submits the data on the form to the database on your Web server. Then, Microsoft Excel closes the form and quits.

On the server, the data is parsed according to the method you specify when you create the form using the Web Form Wizard. The methods you can specify are Microsoft Internet Information Server, or Common Gateway Interface (CGI). If you use Internet Information Server, the data is saved in the Microsoft Access database (.mdb) file that is created by the wizard. If you use CGI, the data is processed by a PERL script and is saved in a .csv text file.

REFERENCES

For more information about the Web Form Wizard, click the Index tab in Microsoft Excel Help, type the following text

   web form wizard

and then double-click the selected text to go to the "About setting up your data gathering system" topic.


Additional query words: 97 XL97 html intranet
Keywords : xladdins xlweb xlwiz kberrmsg kbtool kbualink97
Version : WINDOWS:97
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 15, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.