Microsoft KB Archive/162321

From BetaArchive Wiki

XL97: Excel Articles Available by E-Mail: Functionality



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 functionality of Microsoft Excel 97. 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:

mshelp@microsoft.com

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: Excel Hangs When You Programmatically Save a Workbook

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 Cannot Open a 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: Excel Opens Without Displaying 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 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: Formatting and Cells May Be Lost When Pasting Merged Cells
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

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 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 Do Not Change After Toggling Transition Formula Evaluation
Q159252 XL97: Description and Examples of Data Validation
Q159403 XL97: Data Validation Is Only Accurate with Manual Entry

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

Additional query words: 8.00 97 Excel8 Excel97 msears

Keywords : kbdta
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbinfo
Technology :


Last Reviewed: March 31, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.