Excel 97 Frequently Asked Questions
Table of Contents
Get the latest information about the following categories
New Features in Excel 97
How can I find more information about new features in Microsoft Excel?
How do I specify what data is valid for data entry in cells?
How do I perform a Web query?
How do I create a Hypertext Markup Language (HTML) document from my Microsoft Excel workbook?
How do I troubleshoot problems with my natural language formulas?
Return to Top of Page
New Microsoft Excel 97 User Interface
How can I manually customize my menus and toolbars?
Why does Microsoft Excel stop responding when I create a conditional number format?
Why does a cell display only 1,024 characters when the formula bar displays up to 32,767 characters?
What happens to sound notes when I convert a file from Microsoft Excel 7.0 or earlier?
Does "Merge and Center?" replace "Center across Columns" on the Formatting toolbar?
Why do I receive an error message when I try to use a natural language formula?
Why do I receive an error message when I double-click a workbook file in Microsoft Exchange?
Why can't I see all of the text I typed in a cell?
Why can't I rotate text in an object?
How do I restore a menu that I accidentally deleted?
Return to Top of Page
Excel 97 Error Messages
What causes an invalid page fault in module Gdi32.dll when I start Microsoft Excel 97?
What causes an invalid page fault in module Mso97.dll when I use the AutoCorrect feature?
Return to Top of Page
Maintaining Lists and Using PivotTables and Charts
Why do I receive an error message when I try to sort a range of cells?
Can I create a PivotTable® that is automatically sorted?
How do I create a report template?
How do I share a custom sort order or fill list with another user?
Why can't I create a data table in certain charts?
Return to Top of Page
Migrating from Other Spreadsheet Programs
Are there any new functions in Microsoft Excel 97 that are similar to Lotus® 1-2-3® functions?
What versions of Quattro Pro® are supported by Microsoft Excel 97?
Why don't my Quattro Pro chart objects appear?
Why do my Quattro Pro links return #REF! when I open a sheet in Microsoft Excel 97?
Return to Top of Page
Printing with Excel 97
Why are AutoShapes, objects, and textboxes printed incorrectly?
Why isn't my cloud callout object printed properly by my Hewlett-Packard® printer?
Why is text in my worksheet printed on top of my drawing objects?
Why aren't my print titles printed correctly?
Return to Top of Page
Excel 97 on the Web
How can I find more information about Web features in Microsoft Excel 97?
What is a Web query and how do I create one?
Why can't I open some files by double-clicking them in Windows Explorer?
Can I create a link using the "File" Uniform Resource Locator (URL) format?
Return to Top of Page
Excel 97 Auto Recalculation Patch
I've heard that Microsoft Excel 97 has a problem that may cause values on my worksheets to be calculated incorrectly. Where can I find more information about this problem?
How do I install the Excel 97 Auto Recalculation Patch?
Return to Top of Page
Visual Basic for Applications
What is the new font that is used in dialog boxes and UserForms?
Why doesn't Microsoft Excel run my Auto_Open macro when I open my workbook?
Why can't I add recorded macros to the Tools menu?
Why does my macro stop running when I close a workbook?
How do I create an add-in?
Can I open my add-in to make changes?
How can I programmatically display a UserForm?
Why does my old macro quit when I close the workbook that contains the macro?
Why can't I switch to Microsoft Excel when I am viewing the Object Browser in the Visual Basic Editor?
Why doesn't Microsoft Excel record the appropriate Visual Basic for Applications code when I click certain menu commands or start a wizard?
Where is the "Record at Mark" menu command?
Where are some of the macro options in the Macro Options dialog box?
How can I create a macro that is run when certain application-level events occur?
Why doesn't the OLE Automation code that I use to control Microsoft Excel 7.0 work anymore?
Why do I receive an error message when I use a UserForm from within a Binder file?
Why do I receive a "Type Mismatch" error message when I compare a string to a Boolean variable?
Why does the Office Assistant appear instead of a custom Help topic when I press F1 in a dialog box?
What other Visual Basic for Applications issues should I know about?
Return to Top of Page
Miscellaneous Topics
Why does it seem to take longer to close a file in Microsoft Excel 97?
Why do different menus appear in Microsoft Excel when someone else logs on to my computer?
What is the Microsoft Excel macro virus?
Can I zoom beyond 100% with my Microsoft IntelliMouse™ pointing device?
Why do some new features disappear after someone else works with my workbook?
Why doesn't Microsoft Excel save attached custom toolbars with my workbook?
Why are text boxes that I use in Microsoft Excel 7.0 cut off in various places after I open my file in Microsoft Excel 97?
How do I hide formula errors?
Return to Top of Page
Return to Main FAQ Page
|