Microsoft KB Archive/162321

{|
 * width="100%"|

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: [mailto:mshelp@microsoft.com 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:

"[mailto:mshelp@microsoft.com mshelp@microsoft.com]"

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 :