Microsoft KB Archive/162319

{|
 * width="100%"|

XL97: Excel Articles Available by E-Mail: Components

 * }

-

The information in this article applies to:


 * Microsoft Excel 97 for Windows

-

SUMMARY
This article shows you how to obtain support information from the Microsoft Knowledge Base by e-mail. If you are currently viewing this article on the World Wide Web, this information may not pertain to you.

MORE INFORMATION
The "Article Listing" section of this article includes a subset of Knowledge Base articles about the various Microsoft Excel 97 components. Use the instructions in the "Ordering Articles by E-Mail" section of this article to order items from this list.

Note that because Microsoft Technical Support is constantly adding new information to the Knowledge Base, not all articles are listed here. For this reason, you may want to look on the Web to find the information you are looking for. Microsoft Technical Support on the Web is located at the following address on the World Wide Web:

"http://support.microsoft.com/support/default.asp"

Ordering an Article by E-Mail
To have an article from the list sent to you in e-mail, send a message to mshelp@microsoft.com, and use the Article ID in the subject line of the message, as in the following example:

TO: mshelp@microsoft.com

SUBJECT: Q119591 For more information about how to order an article by e-mail, send an e- mail message to the following e-mail address:

"[mailto:mshelp@microsoft.com mshelp@microsoft.com]"

Microsoft Map
Q159697 XL97: Problems Accessing Microsoft Map Visual Basic Help Files

Q159725 XL97: Map Object Different Depending on Insertion Method

Charts
Q156880 XL97: Using the MenuBars Method in Microsoft Excel 97

Q156890 XL97: Chart Opens More Slowly than in Earlier Versions

Q156894 XL97: Fonts on Chart Title and Label Are Too Large

Q156978 XL97: Chart Data Table Does Not Display All Data Points

Q157110 XL97: Problems When Selecting Error Bars With a Macro

Q157354 XL97: How to View Sample Chart with the Keyboard

Q157539 XL97: "Features May Be Lost" Message Saving File with Chart

Q157558 XL97: Using a Macro to Activate a Chart Changes the Selection

Q157770 XL97: Error When Dragging Chart Into Microsoft Word

Q157826 XL97: Background Turns Black Pasting Object in 3-D Chart Floor

Q157940 XL97: How To Create a Dynamic Chart Using Visual Basic

Q159832 XL97: Inserting Second Trendline into Chart Halts MS Excel

Q160099 XL97: Nothing Is in Printout of Embedded MS Excel Chart

Q160609 XL97: Unable to Create a Transparent Chart Area

Q161006 XL97: Chart Polynomial Trendline Formula Is Inaccurate

Q161218 XL97: Copied and Pasted Chart Appears as Gray Rectangle

Q161348 XL97: Setting Default and User-Defined Chart Types

Q161438 XL97: Crash When Chart Gallery File Is Password Protected

Q161474 XL97: Error Editing Chart Linked to Closed Workbook

Q161530 XL97: Overview of the Built-In Chart Types

Q161660 XL97: Changing the Chart Type Changes the X-Axis

Q161664 XL97: Chart Series Doesn't Use Removed Secondary Axis Scale

Q161670 XL97: How to Plot Values Against a Recommended Range

Q161731 XL97: Chart Display Options Change According to Page Setup

Q161858 XL97: How to Trap Events for an Embedded Chart

Q161929 XL97: Chart Data Range Disappears After Changing Series

Drawing Objects
Q156008 XL97: "Reference Is not Valid" Error Clicking Hyperlink

Q156604 XL97: Text Contained in AutoShapes Does Not Rotate

Q156650 XL97: Cannot Drag Drawing Objects Between Worksheets

Q156953 XL97: Shaded Objects Printed Differently from Earlier Versions

Q156984 XL97: Cannot Drag Drawing Objects onto Windows Desktop

Q157093 XL97: Text May Print on Top of Drawing Objects

Q157298 XL97: Auditing Tools Clear Undo/Redo Stack

Q157413 XL97: Callout Adjustment Handle Disappears When Moved

Q157499 XL97: Picture Linked to Cell Does Not Immediately Update

Q157556 XL97: Problems When Removing Line from Drawing Object

Q157653 XL97: Button Format Carries Over to MS Excel 5 Dialog Sheet

Q157826 XL97: Background Turns Black Pasting Object in 3-D Chart Floor

Q158156 XL97: Shadows on Drawing Objects may not Appear Correctly

Q158353 XL97: Error When Invalid Characters in Drawing Object Name

Q158711 XL97: Cannot Edit Text Box with Unlocked Text

Q158801 XL97: Text Is Truncated in a Text Box with Rounded Corners

Q159002 XL97: Deleting Sheet and Closing Workbook Causes Crash

Q159489 XL97: Grouping ActiveX Option Buttons on a Worksheet

Q159914 XL97: Bitmap Image Shrinks When Pasted on a Toolbar Button

Q160577 XL97: Drawing Object Names Increment Incorrectly

Q160609 XL97: Unable to Create a Transparent Chart Area

Q161746 XL97: Pointer Does Not Change into Hand with ActiveX Controls

Q163741 XL97: Cannot Use xlDisplayShapes with DisplayDrawingObjects

Q163858 XL97: Cannot Click Once to Create Arrows and Lines

Q164814 XL97: Objects or Borders Are Not Printed Correctly

Q166690 OFF97: "Lock Aspect Ratio" Checkbox Doesn't Always Work

Q166760 XL97: Syntax Error Running Macro That Inserts WordArt

Q166987 XL97: Illegal Operation Error Using ListBox Control

Templates
Q156449 XL97: How to Create a Report Template

Q161348 XL97: Setting Default and User-Defined Chart Types

Q161792 XL97: ValuPack Templates Not in Microsoft Excel 97 Format

Built-in Wizards
Q157062 XL97: Cannot Clear "Sort by" List in Query Wizard

Q160648 XL97: Error Using ActiveX Control on Web Form

Q161325 XL97: File Conversion Wizard Included with MS Excel 97

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

Q161898 XL97: Errors in Web Form Wizard Saving Form to FrontPage

Q161899 XL97: Defined Name Is Used by Form Created in Web Form Wizard

Q161902 XL97: Macro Created in Form by Web Form Wizard

PivotTables
Q156314 XL97: How to Use the PivotTable AutoSort Feature

Q157383 XL97: Active Cell Moves Using RefreshTable Method

Q157486 XL97: Limits of PivotTables in Microsoft Excel 97

Q157488 XL97: Using Server Page Fields in PivotTables

Q161538 XL97: How to Use the GetPivotData Worksheet Function

Q161540 XL97: PivotTable Report Unavailable with Parameter Query

Q161882 XL97: Using PivotTable Calculated Fields and Calculated Items

Q163904 XL97: Cannot Use Web Data Source as PivotTable Data

Q166740 XL97: Formula Errors Appear After Updating PivotTable

Help Files
Q156841 XL97: Help for REPT Function Is Incorrect

Q157555 XL97: UserControl Property Code Example Doesn't Work Properly

Q157769 XL97: How to Delete, Restore, and Edit Menu Items Manually

Q159697 XL97: Problems Accessing Microsoft Map Visual Basic Help Files

Q163646 XL97: Some On Events Are Not Displayed in Object Browser

Q163741 XL97: Cannot Use xlDisplayShapes with DisplayDrawingObjects

Q163934 XL97: "Cannot Find the Mainxl.hlp File" When Using Help

Q164920 XL97: DocErr: vbMsgBoxHelpButton Not Listed in Help

Q166338 XL97: Export Method Code Example in Help Is Incorrect

Q166342 XL97: Maximum Array Size in Microsoft Excel 97

Web Components
Q156008 XL97: "Reference Is not Valid" Error Clicking Hyperlink

Q156264 XL97: HTML Document Disappears After Clicking Link

Q156353 XL97: No Menu Choice to Select All Hyperlinks

Q156883 XL97: "Create Hyperlink Here" Does Not Work in Unsaved File

Q156893 XL97: Invalid Site Error Using Relative Hyperlink Path

Q156926 XL97: Unusual Behavior When You Use the HYPERLINK Function

Q156941 XL97: Forward Button on Web Toolbar May Not Be Available

Q157041 XL97: Always Create Backup Fails on Internet FTP Location

Q157309 XL97: Errors Appear When Opening Web Query File on FTP Server

Q157417 XL97: Unable to use File URL in Linking Formulas

Q157482 XL97: How to Create Web Query (.iqy) Files

Q157569 XL97: Can't Select Cells When Using Netscape Navigator

Q158079 XL97: How to Use the Internet Assistant Wizard

Q158247 XL97: Cannot Use Edit Query Button on Sheet With Web Query

Q158300 XL97: "Cannot Open Specified File" Clicking Hyperlink

Q158330 XL97: HYPERLINK Doesn't Work if Second Argument Returns Error

Q159668 XL97: Error Creating Hyperlink with Chart Sheet in Workbook

Q159997 XL97: Illegal Operation Closing File When VBE Is Visible

Q160548 XL97: Error Clicking Save As HTML

Q160600 XL97: ScreenUpdating Causes Problems in MS Internet Explorer

Q160648 XL97: Error Using ActiveX Control on Web Form

Q161071 XL97: DAO Error in Step 3 of Web Form Wizard

Q161437 XL97: Errors Appear When You Access an FTP Site

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

Q161898 XL97: Errors in Web Form Wizard Saving Form to FrontPage

Q161899 XL97: Defined Name Is Used by Form Created in Web Form Wizard

Q161902 XL97: Macro Created in Form by Web Form Wizard

Q163904 XL97: Cannot Use Web Data Source as PivotTable Data

Q163924 XL97: "Unable to Open" Error Performing Web Query

Q164020 XL97: How to Use a Web Data Source for a PivotTable

Q165167 XL97: Links in Shared Workbook Return #REF! Error

Q165779 XL97: External Data Range Property Not Saved with Workbook

Q165780 XL97: Cannot Record External Data Range Properties

Q166829 XL97: Can't Drag Graphics from Internet Explorer

Query
Q156449 XL97: How to Create a Report Template

Q156814 XL97: Adjacent Formulas Left of Data Do Not Fill

Q157090 XL97: Background Queries Suspended While Macro Executes

Q157482 XL97: How to Create Web Query (.iqy) Files

Q158247 XL97: Cannot Use Edit Query Button on Sheet With Web Query

Q158996 XL97: Excel Opens Without Displaying Workbook

Q159557 XL97: Using System, User, and File Data Sources

Q160487 XL97: Parameter Query Is Case Sensitive

Q161540 XL97: PivotTable Report Unavailable with Parameter Query

Q161759 XL97: Query Is Not Executed in the Background

Q163924 XL97: "Unable to Open" Error Performing Web Query

Q164020 XL97: How to Use a Web Data Source for a PivotTable

Q164117 XL97: How to Use Wildcards in Parameter Queries

Q164729 XL97: New Database Query (.dqy) File Format

Q165779 XL97: External Data Range Property Not Saved with Workbook

Q165780 XL97: Cannot Record External Data Range Properties

Q165866 XL97: How to Use File DSNs and DSN-less Connections

Data Access Objects (DAO)
Q157436 DAO 3.0 CopyFromRecordset Method Not Compatible With XL97

Q157471 XL97: Run-Time Error Using CreateObject With DAO.DBEngine

Q158066 XL97: Reference to DAO 3.0 Changes to DAO 3.5 When File Opened

Toolbars and Menus
Q161322 XL97: How to Use Custom Toolbars in Excel5.xlb

Q161509 XL97: Status Bar Text Not Displayed When You Point to Toolbar or Menu Item

Q161539 XL97: Customizing Menus and Toolbars Without Customize Dialog

Q161694 XL97: Control Toolbox Toolbar Disappears

Q161746 XL97: Pointer Does Not Change into Hand with ActiveX Controls

Q165240 XL97: Redo Toolbar Button Does Not Repeat Formatting

Add-ins
Q143466 XL97: Macro97.exe File Available on Online Services

Q156879 XL97: Visual Basic Modules Cannot Be Hidden or Protected

Q157311 XL97: Problems with Recorded Macro That Creates Map Object

Q157348 XL97: All Views Listed in Custom Views and Report Manager

Q157768 XL97: Not all Menu Items Appear for Other Users

Q158079 XL97: How to Use the Internet Assistant Wizard

Q159157 XL97: Convert to MS Access Menu Command May Work Incorrectly

Q159223 XL97: Macro Recorder Doesn't Record Some Menu Commands

Q160085 XL97: Page Fault Accessing Demand-Loaded Add-in

Q160131 XL97: Cannot Modify Microsoft Excel 5.0 or 7.0 Add-in

Q160548 XL97: Error Clicking Save As HTML

Q160648 XL97: Error Using ActiveX Control on Web Form

Q161071 XL97: DAO Error in Step 3 of Web Form Wizard

Q161325 XL97: File Conversion Wizard Included with MS Excel 97

Q161439 XL97: How to Remove Entries from Add-Ins Dialog Box

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

Q161898 XL97: Errors in Web Form Wizard Saving Form to FrontPage

Q161899 XL97: Defined Name Is Used by Form Created in Web Form Wizard

Q163271 XL97: Error Appears or View Not Retained Printing Reports

Q163885 SBFM97: Quickbooks 4.0 Filter Fails Under Windows NT 4.0

Q164283 SBFM97: Cannot Find the Aapc.hlp in Canadian SBFM

Q163680 SBFM97: Run-Time Error '13' In Buy vs. Lease Analysis

Q164745 SBFM97: Total Monthly Payments Calculation Is Incorrect

Q164995 SBFM97: List of Supported Accounting Programs

Q166746 SBFM97: Files Installed with Small Business Financial Manager

Q166766 SBFM97: Payments Per Year Input Box Only Allows One Digit Additional query words: Excel 8.00 Excel8 Excel97 msears xl97 Fast tips

Keywords : kbdta

Version : WINDOWS:97

Platform : WINDOWS

Issue type : kbinfo

Technology :