ID: Q162321
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 functionality of Microsoft Excel 97. 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
Q157768 XL97: Not all Menu Items Appear for Other Users
Q161235 XL97: How to Use a Toolbar Settings File from a Network Share
Q156953 XL97: Shaded Objects Printed Differently from Earlier Versions
Q156983 XL97: Print Titles with Merged Cells Add Columns or Rows
Q157093 XL97: Text May Print on Top of Drawing Objects
Q157099 XL97: Borders Below Row 65536 Do Not Print
Q157348 XL97: All Views Listed in Custom Views and Report Manager
Q157557 XL97: Cloud Callout Is Not Printed Correctly on HP Printer
Q159227 XL97: Drawing Objects and AutoShapes Aren't Printed Correctly
Q159493 XL97: Macro to Create Data Validation Circles for Printing
Q159754 XL97: Page Numbers in "Now Printing" Dialog May Skip Numbers
Q160099 XL97: Nothing Is in Printout of Embedded MS Excel Chart
Q160342 XL97: Error Printing Microsoft Excel Section in a Binder
Q160539 XL97: Error Printing Page Number Greater Than 32,767
Q161607 XL97: Macro to Change the Date/Time Format in a Header/Footer
Q163271 XL97: Error Appears or View Not Retained Printing Reports
Q163274 XL97: Error Using Page Setup with Canon MultiPASS C2500
Q164024 XL97: Printing Problem When Print Titles Contain Borders
Q143452 XL97: Excel Hangs When You Programmatically Save a Workbook
Q156443 XL97: Files Increase in Size When Saved in XL97 Format
Q156449 XL97: How to Create a Report Template
Q156942 XL97: How to Create an Add-in File in Microsoft Excel 97
Q156943 XL97: How to Convert an Add-in File into a Workbook
Q157027 XL97: Attached Toolbar Is Not Saved in 5.0/95 File Format
Q157041 XL97: Always Create Backup Fails on Internet FTP Location
Q157320 XL97: Macro Can't Open File That has no Extension
Q157497 XL97: Using the Microsoft Excel 97 & 5.0/95 Workbook Format
Q158156 XL97: Shadows on Drawing Objects may not Appear Correctly
Q158543 XL97: Double-Clicking Workbook in MS Exchange Causes Error
Q158748 XL97: Cannot Use Quick View for MS Excel 97 Files
Q158921 XL97: File Password Lost Moving File to an Exchange Folder
Q158996 XL97: Double-Clicking in Explorer Doesn't Open Workbook
Q159002 XL97: Deleting Sheet and Closing Workbook Causes Crash
Q159361 XL97: Read-Only Recommended Opening 97 & 5.0/95 File Format
Q159465 XL97: "Module Not Found" Error Opening Workbook
Q159679 XL97: "Illegal Operation" Opening a Non-Microsoft Excel File
Q159877 XL97: Crash Saving Workbook If Module Name Contains Equal Sign
Q160032 XL97: Invalid Page Fault Saving a Workbook or Add-In
Q160085 XL97: Page Fault Accessing Demand-Loaded Add-in
Q161325 XL97: File Conversion Wizard Included with MS Excel 97
Q161393 XL97: Macro to Open the Most Recently Used File
Q161437 XL97: Errors Appear When You Access an FTP Site
Q161486 XL97: Macro to Change File Type to *.* in Open Dialog Box
Q161512 XL97: GetSaveAsFilename Method Returns Extra Character
Q161792 XL97: ValuPack Templates Not in Microsoft Excel 97 Format
Q163102 XL97: "File Format Not Valid" Appears Opening Routed Workbook
Q154874 XL97: How to a Create Conditional Format to Hide Errors
Q156888 XL97: Paste Function Buttons Missing in Formula Palette
Q156889 XL97: Indent Option Not Available with General Alignment
Q156892 XL97: MS Excel Stops After Specifying Conditional Format
Q156953 XL97: Shaded Object Is Printed Differently to HP 5MP
Q156978 XL97: Chart Data Table Does Not Display All Data Points
Q157028 XL97: Pasting Merged Cells May Clear Cells in Destination
Q157097 XL97: Cannot AutoFit Rows/Columns That Contain Merged Cells
Q157099 XL97: Borders Below Row 65536 Do Not Print
Q157102 XL97: EnableSelection Property May be Overridden
Q157111 XL97: Error When Sorting a Range Containing Merged Cells
Q157202 XL97: Color Palette Looks Different in Microsoft Excel 97
Q157204 XL97: Odd Behavior Using Format Painter and Merged Cells
Q157413 XL97: Callout Adjustment Handle Disappears When Moved
Q157499 XL97: Picture Linked to Cell Does Not Immediately Update
Q157826 XL97: Background Turns Black Pasting Object in 3-D Chart Floor
Q157938 XL97: Conditional Format Applies Format for First Condition
Q158139 XL97: Fill Values Fills Series with Merge Cells Formatting
Q158711 XL97: Cannot Edit Text Box with Unlocked Text
Q158879 XL97: ;;; Number Format Fails to Hide Cell Contents
Q159252 XL97: Description and Examples of Data Validation
Q159319 XL97: CTRL + Autofill Does not Increment Values
Q159321 XL97: Format not Applied on Grouped Sheet with Merge Cells
Q159403 XL97: Data Validation Is Only Accurate with Manual Entry
Q159464 XL97: Automatic Styles and Apply Styles Do Not Apply Format
Q159622 XL97: Cannot Change Value for Form Control on a Worksheet
Q159863 XL97: Problems When you AutoFormat an Entire Worksheet
Q161241 XL97: Data Overwritten Copying More Than 31,737 Characters
Q161607 XL97: Macro to Change the Date/Time Format in a Header/Footer
Q161688 XL97: Pasting in Merged Cell Duplicates Copied Cells
Q163231 XL97: Format Cells Sample May Display Number Signs
Q163495 XL97: Formats May Not Be Applied to Pasted Merged Cell
Q163678 XL97: Err Msg: "Too Many Different Cell Formats"
Q164024 XL97: Printing Problem When Print Titles Contain Borders
Q154874 XL97: How to a Create Conditional Format to Hide Errors
Q156350 XL97: AutoFill Limited to 255 Characters
Q156445 XL97: New A Functions in Microsoft Excel 97
Q156603 XL97: Microsoft Excel Inserts a Defined Name in Formula
Q156814 XL97: Adjacent Formulas Left of Data Do Not Fill
Q156836 XL97: CTRL+SHIFT+" Keyboard Shortcut Limited to 1,024 Characters
Q156841 XL97: Help for REPT Function Is Incorrect
Q156869 XL97: Pasting Entire Column Is Slower than in Earlier Versions
Q156881 XL97: Only 1024 Characters Are Displayed in a Cell
Q156888 XL97: Paste Function Buttons Missing in Formula Palette
Q156891 XL97: Undo Does Not Always Restore Previous Value
Q156926 XL97: Unusual Behavior When You Use the HYPERLINK Function
Q157028 XL97: Pasting Merged Cells May Clear Cells in Destination
Q157031 XL97: Calculation of Formula in Formula Bar Returns #VALUE!
Q157034 XL97: Cannot Use External References with Data Validation
Q157095 XL97: Natural Language Formulas Return Error
Q157111 XL97: Error When Sorting a Range Containing Merged Cells
Q157112 XL97: Cell References in Copied Formula Incorrect
Q157417 XL97: Unable to use File URL in Linking Formulas
Q157483 XL97: Limit on Natural Language Formulas per Worksheet
Q157484 XL97: Error When Using Validation Drop-Down List Box
Q157499 XL97: Picture Linked to Cell Does Not Immediately Update
Q157610 XL97: Problems When AutoFilling Very Large Time Frames
Q158080 XL97: Cannot Paste Array Formula in its Original Cell
Q158097 XL97: File Name in Formula Doesn't Appear Correctly
Q158300 XL97: "Cannot Open Specified File" Clicking Hyperlink
Q158330 XL97: HYPERLINK Doesn't Work if Second Argument Returns Error
Q158540 XL97:Results Unchanged Toggling Transition Formula Evaluation
Q159252 XL97: Description and Examples of Data Validation
Q159403 XL97: Data Validation Is Only Accurate with Manual Entry
Q159416 XL97: Error Inserting or Deleting Rows or Columns After Undo
Q159958 XL97: Unexpected Results Paste Linking Noncontiguous Range
Q160206 XL97: Reference for ListFillRange Does Not Update Properly
Q160523 XL97: Cannot Use Custom Function with Data Validation
Q160543 XL97: Error Evaluating Natural Language Formula
Q161006 XL97: Chart Polynomial Trendline Formula Is Inaccurate
Q161538 XL97: How to Use the GetPivotData Worksheet Function
Q161546 XL97: How the Current Mode of Calculation Is Determined
Q161747 XL97: List of Errors That Formula AutoCorrect Detects
Q161757 XL97: Countif Function May Not Work with Blank Cells
Q161882 XL97: Using PivotTable Calculated Fields and Calculated Items
Q162323 XL97: Contents of the Samples.xls Workbook
Q162474 XL97: DFunctions Return Errors When Database Has Too Many Rows
Q161438 XL97: Crash When Chart Gallery File Is Password Protected
Q163049 XL97: Illegal Operation Using Chart Wizard
Additional query words: 8.00 97 Excel8 Excel97 msears
Keywords : kbdta
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbinfoLast Reviewed: May 28, 1999