ID: Q162319
The information in this article applies to:
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.
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
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
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
using (for example, for Microsoft Word, select 2).
4. From the "FastTips Main Menu," select 1 to place a FastTips catalog
order.
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.
code and seven-digit fax number.
If you have problems receiving a fax, please call the FastTips Hotline at (425) 635-3199.
ARTICLE ID ARTICLE TITLE
Q159697 XL97: Problems Accessing Microsoft Map Visual Basic Help
Files
Q159725 XL97: Map Object Different Depending on Insertion Method
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
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
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
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
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
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
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
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
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
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
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 : WINDOWSLast Reviewed: November 4, 1998