Microsoft Excel Articles Available by Fax or E-Mail: Components

• Microsoft Excel 97 for Windows

SUMMARY

This article shows you how to obtain support information from the Microsoft Knowledge Base by e-mail or by fax. 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 or by Fax" 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 ARTICLES BY E-MAIL OR BY FAX

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" (without the quotation marks), and use the Article ID in the subject line of the message, as in the following example:

     TO: mshelp@microsoft.com
     SUBJECT: Q119591

   mshelp@microsoft.com

Ordering an Article over the Phone and Having It Sent to a Fax Machine

To have an article sent to a fax machine, use the Microsoft FastTips System. Microsoft FastTips is available 24 hours a day, 7 days a week, from a touch-tone telephone. To order items from this article list, first note the five- to six-digit number of the Article ID shown for each item, and then follow these steps:

1. Dial the toll-free FastTips number:

         (800) 936-4100
   

2. When prompted, select the appropriate number for the product you are using (for example, for Microsoft Word, select 2).

3. When prompted, select the version of the product that you are using.

4. From the "FastTips Main Menu," select 1 to place a FastTips catalog order.

5. At the "to order items from your catalog" prompt, select 1.

6. When prompted with the "at the tone, enter the item ID number followed by the pound key" message, enter the Article ID number from the following list and press # (use the numbers following "Q," but do not include "Q").

         NOTE: You can order up to five items at a time.
   

7. When prompted, select the fax option and enter your three-digit area code and seven-digit fax number.

8. When you're finished ordering, hang up.

ARTICLE LISTING

ARTICLE ID ARTICLE TITLE

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: Chart Activation with Macro Changes 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 Chart Type Changes 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 Panel
Q165930    XL97: Some Objects Not Saved in Custom Chart

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

Q165930    XL97: Some Objects Not Saved in Custom Chart
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: Double-Clicking in Explorer Doesn't Open 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
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