When you are working in a design program, you can get help in the following ways:
- Design program Help For information about the commands and features available in the design program that you can use to work with spreadsheets, see Help in the design program. For example, in Microsoft FrontPage, click the Office Assistant, or click Microsoft FrontPage Help
.
Microsoft Excel provides both general Help about saving Excel data for use on Web pages, and specific information about saving spreadsheets for use on Web pages. To access this Help in Excel, click the Office Assistant, or click Microsoft Excel Help
. - Spreadsheet design-time Help If you have access to the Commands and Options dialog box in another design program, you have access to the Help topics you are viewing now. In a spreadsheet that you have created or activated in a design program, click Help
in the Commands and Options dialog box or click Help on the spreadsheet toolbar.
Getting help with writing scripts and programs that use spreadsheets
You can use scripts and programs to automate spreadsheets, or you can include spreadsheets in run-time programs other than Web browsers
Writing scripts Microsoft Office programs provide the Microsoft Script Editor to help you write scripts. For example, you can use the Script Editor in Microsoft FrontPage to customize a spreadsheet. For information about running the Script Editor, see Help in your Office design program. In the Script Editor, you can display additional Help about using its features and writing scripts.
Object model Help For help developing a program or script to work with a spreadsheet, you can display information about the object model, properties, and methods specific to spreadsheets. This object model Help is installed whenever you install the Microsoft Office Web Components, of which the Spreadsheet Component is one. Depending on the design program you're using, you can access this Help in either of two ways:
- Help in Microsoft Visual Basic In Visual Basic or Microsoft Visual Basic for Applications (VBA), you can create a reference to the Office Web Components library. You will then have access to Help through the object browser or by selecting a keyword and pressing F1. For information about creating references and using object model Help, see Help in Visual Basic or VBA.
- Help in other environments If you are using another development environment, locate and double-click the Help file owcvba11.chm.
Getting and providing help in the browser
In the browser, Help explains how to use the features and capabilities of spreadsheets. Depending on the skills of your users and the type of work they want to do, you might want to supplement this run-time Help by providing custom instructions on the Web page for your spreadsheet, or providing a hyperlink to another Web page that has instructions on it.
Help available from the browser For users who have Microsoft Internet Explorer version 5.02 SP2 or later and the Microsoft Office Web Components, general Help specific to spreadsheets is automatically available. This run-time Help is separate from the Help available from the browser's Help menu.
The run-time spreadsheet Help topics provide general information for all users about using spreadsheets in the browser
To see what Help is provided in the browser, create a spreadsheet on a Web page, open the Web page in Internet Explorer, click the spreadsheet, and then click Help
on the spreadsheet toolbar. In the Help window, you can view a table of contents and search the topic text. The Office Assistant is not available in the browser to answer questions.
Getting help for the Spreadsheet Web Part
The Spreadsheet Web Part combines the use of several technologies, including Windows SharePoint Services, Microsoft Office 2003, Microsoft Office Excel 2003, and Microsoft Office Web components. The Spreadsheet Web Part is in essence the Spreadsheet component hosted within a Web Part. The Help information you might need to use this Web Part is available from several different locations.
Getting Spreadsheet Web Part Help
The Spreadsheet Web Part Help topics are context-sensitive Help topics that answer questions you might have specific to the Web Part, such as what is its purpose, how to use it, what are the common and custom properties, how to make connections to other Web Parts, and how to troubleshoot problems.
This Help information becomes available when you install the Microsoft Office Web Parts and Components product on a Windows SharePoint Services server.
To display Spreadsheet Web Part Help information, on the Web Part menu, click Help.
Getting Microsoft Office Spreadsheet Component Help
The Spreadsheet Component is self-contained and can be incorporated into other Microsoft Office products and user-designed applications. The Microsoft Office Web Components contain a separate Help system designed to explain how to use them.
This is the Help information you are reading now, which becomes available when you install the Microsoft Office Web Components on your computer.
To get Office Spreadsheet Component Help information, on the Spreadsheet Component toolbar, click Help.
Getting Windows SharePoint Services Help
The Windows SharePoint Services Help system provides information you may need about features related to the Spreadsheet Web Part, especially creating, using, and managing Web Part Pages.
This Help information becomes available when an administrator installs Windows SharePoint Services on a server.
To display this Help information, click Help on the top link bar.
Getting Data Connection Wizard Help
The Data Connection Wizard is used in several Microsoft Office applications, including the Spreadsheet component and the Spreadsheet Web Part.
This Help information becomes available when one or more Microsoft Office products are installed on your computer.
To display this Help information, see the following Help topics in any Microsoft Office product: "More about Office data connection files" and "More about data sources".
Getting Custom Spreadsheet Web Part Help
The Help information for creating a custom Spreadsheet Web Part is available in Microsoft Office Excel 2003.
This Help information becomes available when Excel 2003 is installed on your computer.
To display this help information, see the following Help topics in Excel 2003 Help: "About the Spreadsheet Web Part," "Create a data-bound Spreadsheet Web Part," and "Create a connectable Spreadsheet Web Part." In the Table of Contents, click Excel and the Web and then click Use the Spreadsheet Web Part.
Getting Help from additional Microsoft Web sites
The following Microsoft Web sites are good sources of additional, up-to-date information about using and customizing the Spreadsheet Web Part: