MS Excel Articles Available by Fax or E-Mail: Functionality

• 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 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

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

Installing

Q157768    XL97: Not all Menu Items Appear for Other Users
Q161235    XL97: How to Use a Toolbar Settings File from a Network Share

Printing

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

Loading and Saving Files

Q143452    XL97: MS 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

Formatting Worksheets

Q154874    XL97: How to a Create Conditional Format to Hide Errors
Q156888    XL97: Paste Function Buttons Missing in Formula Palette
Q156889    XL97: Indent Label in Format Cells Alignment Tab Is Dimmed
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 MS 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: Number 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

Using Formulas

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 Returns 1024 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

Faults and Crashes

Q161438    XL97: Crash When Chart Gallery File Is Password Protected
Q163049    XL97: Illegal Operation Using Chart Wizard