CLAY JOHANSON'S KNOWLEDGE BASE ARTICLE LIST

From March 1992 until September 2000, I was a support professional at Microsoft. One of my many duties in this role was the development of articles for the Microsoft Knowledge Base. In my eight and a half years at Microsoft, I wrote over 1250 articles: I'm the 4th most prolific article writer in Microsoft history. Since I was in the Office/Excel group, my concentration was on articles related to Office and Excel. However, some of my earlier articles deal with Windows and other associated stuff (like the Windows Sound System).

At any rate, I've compiled a listing here of all of my articles. (NOTE: This does not count articles that were "cloned" for other languages or newer product versions, and for which I have received writing credit. I personally wrote all of the articles listed here.) Some of these articles are intended for internal use only or have been archived, so if you click their links you won't get to see the article. All of the other links should be valid; if you click a link and the article doesn't show up, send me mail, and I'll have someone check it out. I don't promise anything... but I will investigate the problem. As always, your mileage may vary. I'll update this list whenever I get a chance. For the most current info, head on over to the Microsoft support page.

So... here's the list:

Q84848Typecase's Font Compression Feature May Cause GP Faults
Q84952CapsKey May Conflict with Windows Recorder
Q85315Norton Desktop 2.0 Adds Options to Windows 3.1 File Manager
Q86685Excel: Using COMPARE.XLA Generates Macro Error
Q87540Excel: ASSIGN.TO.TOOL and ENABLE.TOOL Cause Macro Error
Q87987Excel Err Msg: Margins Do Not Fit Page Size
Q88588Excel: Missing Help Topic for Illegal Reference Argument
Q88686Excel: Regression Dialog Box Does Not Fit 9-inch Screen
Q88748Excel: Preferred Chart Format Doesn't Save Legend Position
Q88981Excel: Floating Toolbars Not Displaying Correctly
Q89027Excel: Data Extraction Copies Most Cell Formatting
Q89615Hauppauge Win/TV and Windows
Q89741Excel: Axes Inaccessible When Concealed by Other Axes
Q89742Excel: No Working Models Available for Excel 4.0
Q89790Excel: 7th Nested IF in Formula Can't Contain AND and OR
Q89983Excel: ChartWizard Changes Title, X Axis, and Y Axis Fonts
Q90785Excel Err Msg: "Help Topic Does Not Exist" with 1-2-3 Help
Q90798Excel: Inactive Workbook Scroll Bars Activate Contents Buttons
Q91206Excel: 1-2-3 Help Topic not Available Message Displays Twice
Q91691Excel: Display Problems with E-Machines TX Color Monitor
Q92773WFWG: Problems when Windows Express Version 3.0 Run as Shell
Q93254Excel: Text Values in XY (Scatter) Chart Change Format
Q93433Excel Err Msg: 'Disk Is Full' when Installing to Remote Drive
Q93446Excel: Radius Pivot Monitor May Hang Excel Version 4.0
Q93596UNCONF: Excel: Error Exporting DBF 4 Format Files
Q94017Excel: Can't Use Switch To Add-In Macro with PowerPoint 3.0
Q94201TopDesk Conflicts with SoundBits Sound Events
Q94202Excel: #VALUE! Error When Concatenating Cells
Q94354Excel: AVI Files Are Not Played in Excel Client Window
Q94355Excel: Display Errors with Excel Setup When Using TopDesk
Q94560Sound Finder & Quick Recorder Description & Label Text Limits
Q94594Windows Sound System and Berkeley Systems' Screen Savers
Q94605Excel: WORKDAY Function Returns #NUM! If Days Equal Zero
Q94631XL: Regression Tool Error If More Than 16 X Ranges
Q94633Excel: FILE.OPEN Command Macro Does Not Exist
Q94861Excel: Editing R1C1 Formatted Cells Doubles Spaces
Q94934Excel: Fourier Analysis Tool Returns Error Message
Q95196Excel Err Msg: 'Name Cannot Be the Same As Built In Name'
Q95627Excel: Desktop Granularity May Affect Tutorial
Q95810XL2/XL3: OPEN.LINKS May Open Files When No Links Exist
Q95888XL: "Save Changes in 'Sheetname'?" When No Changes Made
Q95976Excel: Corrupted (Garbled) Menu Text
Q95988Excel: Moving Average Chart Does Not Reflect Data
Q95989Testing for a Damaged Macintosh Operating System
Q96136XL3/XL4: STDEVP Function Returns #NUM! Error Value
Q96381Excel: RANDBETWEEN Does Not Return Correct Distribution
Q96436XL: LINEST or REGRESS Error Value When X-Values Dependent
Q96594XL: Auto Save Doesn't Save Sheets Bound in Workbooks
Q96746XL: Using RAND() to Generate Randomly Distributed Integers
Q96791Excel: EDATE() Returns #VALUE! Error Value or All Results Same
Q96813Excel: SAVE() Macro Command Saves File in Last Saved Format
Q97150Excel: ChartWizard Doesn't Add Close Marks to Stock Charts
Q97916XL: Reports Aren't Printed at Reduced Size
Q98177Excel: FOPEN() Macro Fails when More Than Eight Channels Open
Q98453Excel: Circular Reference Error Using MATCH
Q98608XL: PRINT() Command Limited with Certain Printers
Q98717Excel: Crosstab ReportWizard Returns Error if Sheet Protected
Q98979XL4: Crosstab ReportWizard May Overwrite Data
Q98981Excel: Using GET.CELL() to Detect an Apostrophe in a Cell
Q99003Excel: SHIFT+Close All Does Not Bypass Auto_Close Macros
Q99348XL: Macroless Method to Display the File Name of a Worksheet
Q99349XL: Working with Time Periods That Exceed 24 Hours
Q99350Excel: Limits on Number of Categories in Crosstab Wizard
Q99366XL: Solver Fails on Worksheet with Apostrophe in File Name
Q99983XL: "Smart" Apostrophes Cause Errors when Checking Spelling
Q100788UNCONF: Excel: Hidden Windows May Be Created in Workbooks
Q100944XL3/XL4: Macro to Open an Add-in for Editing
Q100982Pooled Variance Wrong in t-Test Two-Sample Unequal Variances
Q101433Can't Define Name for Formula with OFFSET() and INDIRECT()
Q101455Excel: SELECT.END() Doesn't Work on Minimized Worksheets
Q101621Excel: Macro Commands to Show or Hide All Toolbars
Q101939XL: How Chart Axis Limits Are Determined
Q102335Excel: OLE Sound May Not Work if SoundBits Is Installed
Q102438Excel: Methods for Conserving GDI Resources
Q102616XL: Cannot Activate or Change Protected Objects
Q103127Excel: Cannot Mask Password in Custom Dialog Box
Q103169Excel: Can't Define Names with Backslash and Single Character
Q103283Office: Support of OEM Versions of Microsoft Office
Q103391Excel: Embedded Paintbrush Object Not Automatically Updated
Q103511Excel: Cannot Change Size of New Windows
Q103512Excel: Extra Characters Displayed in Pie Chart
Q103566Excel: Must Have File Functions Add-in to Use CREATE.DIRECTORY
Q103635Excel: Cell A1 Always Active When WK3 File Opened
Q103736Excel: Running Access Pack Causes Null Selector Fault in Setup
Q103737Excel: Header/Footer Printed But Not Visible in Page Setup
Q104089Excel: Using Help Tool with Text Boxes Brings Up Wrong Topic
Q104225Excel: Number of Files Allowed in Linked List Box
Q104442Excel: Entering Multiple Lines in an Input Box
Q104480UNCONF: Excel: Configuring Raster Ops Monitors
Q104481Excel: Cannot Access System Menu While Macro Is Running
Q104583Excel: POISSON() Function Returns #NUM! Error Value
Q104625XL: Problems with SOLVER Functions
Q104626Excel: NPER() Function Returns #NUM! Error Value
Q104695XL3/XL4: How the Current Mode of Calculation Is Determined
Q104696Excel: "Not Enough Memory" Error When Defining Names
Q104754Excel: Novy Accelerator May Cause Excel to Crash
Q104786XL5: Dialog Sheets Limited to One Dialog Box Per Sheet
Q104837Excel Err Msg: "Cannot Open Protected File," with Text File
Q104838XL5: Can't Clear Entire Contents of Cell with Shortcut Menu
Q104840XL: Assigning an Access Key to a Custom Dialog Box Control
Q104841Excel: Problems Using Ampersands in Headers and Footers
Q104936XL: Double-Clicking Control Activates Default Button
Q105036XL5: Unable to Resize Spinner Control to Desired Height
Q105098XL5: Find File Subdirectory Search Limitations
Q105110XL: Can't Link Edit Box to Worksheet Cell from Control Tab
Q105136XL: Creating Pivot Table from External Data Hangs Computer
Q105202XL: No Direct Visual Basic Equivalent for SOUND.PLAY()
Q105203XL: Print Selection Does Not Ignore Print Titles
Q105411XL: Financial or Accounting AutoFormats Change Number Formats
Q105412XL: Cannot Drag, Cut, or Copy AutoFilter Drop-down List
Q105414XL: Computer Beeps, Cells Not Selected with PAGE UP/PAGE DOWN
Q105449XL: International Settings Not Updated Automatically
Q105450XL: Cannot Select Local Name By Pressing Its First Letter
Q105451XL: Not All Toolbars Listed on Popup Menu
Q105509MXL Err Msg: Bad F-Line Instruction
Q105543XL: No Resume Button or Key Command for Paused .XLM Macro
Q105552XL: Static and Dynamic Default Buttons in Dialog Boxes
Q105571XL: Function Name Can't be Same as Module Name
Q105769XL: Can Use Same Name to Define Object and Defined Name
Q105770XL: Cannot Use Name Box to Define 3-D Name
Q105817XL: Defined Names for Print Area or Titles May Not Be Dynamic
Q105818XL: Too Many Cells Pasted When You Copy Data to Lotus 1-2-3
Q105877XL: RemoveItem and RemoveAllItems Methods May Not Work
Q105880XL5: Can't Define or Delete Names When in Group Edit Mode
Q106004XL: Macro Cannot Scroll Chart Sheet
Q106005XL: Can't Step Through Excel 4.0 Macro If Dialog Box Visible
Q106006XL: Err Msg: Redefine Scenario Based on Current Cell Values?
Q106007XL: Dates in Unexpected Order in AutoFilter Drop-down List
Q106008XL: Open Subroutines Run Before Referenced Subroutines
Q106009XL: Macro to Restore Tab Split Box to Default Position
Q106069XL: Debug Window Appears Behind Floating Toolbars Until Moved
Q106150XL: Minus Sign Appears Before Text in Custom Number Format
Q106206XL: Error Using Data Form If Too Many Fields Are Present
Q106251XL: Print Area and Print Titles Boxes Empty in Print Preview
Q106252XL: Formats Not Copied When More Than One Format Used in Cell
Q106338XL: Can't Use Varied Formats When Text Box Is Linked to Cell
Q106339XL: Days of the Week Before March 1, 1900 Are Incorrect
Q106340XL: Tabs Appear Strange in TextWizard
Q106556XL: Non-English Months Incorrectly Interpreted as Text
Q106718XL: Unexpected Results When Pasting Linked Text Box
Q107138XL: Character Format of Numbers Changes with AutoFill Feature
Q107221XL: Using "Most Recently Used" Category in Function Wizard
Q107222XL: Copy Picture Does Not Copy Row or Column Headings
Q107254Cannot Disable ToolTips Directly from Microsoft Query
Q107536XL: Cannot Create Wallpaper Effect in Chart Sheet
Q107545XL: Multiple Sheets Inserted with Autotemplate
Q107622XL: How To Add a Sheet After Last Sheet in a Single Action
Q107623XL: Error Unhiding Multiple Sheets in Visual Basic
Q107906XL5: Find File Opens Add-in as Unhidden and Ignores Auto_Open
Q107975XL: 4.0 Menus Different From Actual 4.0 Menus
Q107976XL: Objects Setting Applies to Entire Workbook
Q107977XL5: Unexpected Settings/Values If 4.0 Workbook Opened in 5.0
Q108061MSQuery: May Not Receive Error Message with Invalid Query
Q108081XL5: Explanation of How Items Appear in Window Menu in 5.0
Q108106XL5: Text in Copy To Box Appears Available in Advanced Filter
Q108282XL: No Size Option Given When Copying Picture of a Chart
Q108350XL: Distinguishing Sheet Types with Visual Basic Macro
Q108351XL: ChDir May Fail When Changing to a Root Directory
Q108352XL5 Err Msg: "Locked Cells Cannot Be Changed" in Dialog Sheet
Q108358XL: Errors If XL5GALRY.XLS Is Saved with Password
Q108359XL: Cannot Define Name If Active Sheet Protected
Q108507XL: Error When Macro Closes Its Own Workbook
Q108508XL: Selection.Rows.Count May Return Incorrect Result
Q108517XL: Error Getting the Value of a Name in Visual Basic
Q108518XL: Range.EntireRow May Return Incorrect Result
Q108519XL: Running Subroutines and Macros from Visual Basic
Q108640XL5: Pasting Object Creates Hidden Worksheet
Q108641XL5: Headings May Have Different Color Than Gridlines
Q108643XL5: Subroutine Can't Tell Which Sheet Tabs Are Visible
Q108800XL: Legend Hides Gridlines and Plot Area Edges
Q109110XL: Color Missing in Plot Area Formatted as Pie or Doughnut
Q109111XL: Book1 Disappears When You Open a Previously Saved File
Q109112XL: Odd Dots and Lines in Copied Picture of Dialog Box Frame
Q109177XL5: Filename Not Displayed When Protected File Opened
Q109178XL: Toolbars May Be Lost When Exiting Full Screen Mode
Q109205XL: All PageSetup Settings Are Recorded into Macro
Q109207XL5: Can't Sign Out of Microsoft Mail After Routing Document
Q109208XL: Function Subroutines Can Show Message Boxes
Q109209XL5 Err Msg: "Not Enough Memory" With Indirect Defined Names
Q109210XL: Odd Window Behavior After Inserting a Workbook
Q109212XL: Sort By Set To "(none)" Causes Error Message
Q109245XL: Can't Access Name Box with Key Commands
Q109246Cannot Open Microsoft Works 3.0 or 4.0 Files
Q109275XL5: Errors When Trying to Use Charting Toolbar Buttons
Q109297XL5: Formulas Incorrect When File Saved in SYLK Format
Q109417XL5: Cannot Replace Default Module with Autotemplate
Q109418XL: Verifying the Value of a Check Box
Q109419XL: Can't Access Add-Ins When in Group Edit Mode
Q109420XL: Dates in Pivot Table May Be Converted into Text
Q109421XL5: Can't Preview Word for Windows Files in Find File
Q109422XL5: Formatting Dialog Frame When Sheet Protected Hangs Excel
Q109423XL: Not Possible to Position Custom Dialog Boxes
Q109424XL: How to Use the Help Button in Custom Dialog Boxes
Q109425Can't Start Programs from Microsoft Toolbar
Q109426XL5: X Values Tab May Be Missing from Chart Format Dialog
Q109427XL5: Longer Tips Do Not Appear in Bold Text
Q109428XL5: "Save Changes in <Bookname>" Even If No Changes Made
Q109429XL5: GP Fault Entering User Defined Function Without Arguments
Q109652XL5: Query Reconnection Information Not Secure
Q109689XL5: Reading and Writing .INI Files in Visual Basic
Q110006XL: Update Remote References Option Selected by Default
Q110186XL5: System Appears to Hang When Creating Chart
Q110357MSQuery 1.0: Paradox 4.x File Format Not Supported
Q110372Error Returned If You Don't Restart Windows After Setup
Q110382XL5: Determining If a Customer Is Using a Beta Build of Excel
Q110383XL: GET.DOCUMENT(67) Always Returns TRUE
Q110462XL: ShowDataForm Method Fails If Data Can't Be Found
Q110624XL: Problems When Two Windows Share the Same Title
Q110626XL5: Some Options on Edit Tab Produce Wrong Code when Recorded
Q110708XL: Formatting and Charts Not Saved to .WQ1 Format
Q110709XL5: Drag to Replace in Recorded Macro Returns Invalid Code
Q110859XL: Chart Series May Not Be Printed in Black and White
Q110860XL5: After Setup, Choosing Continue Button Restarts Windows
Q110861XL5: GP Fault May Occur When Too Many Code Panes Are Open
Q110862XL: Function Wizard Doesn't Enter Formulas as Arrays
Q110944XL: Error Messages When Accessing Files from Floppy Disks
Q111086XL: Cannot Display Visual Basic Modules in Print Preview
Q111087XL5: Page Setup Settings Not Saved with Visual Basic Modules
Q111088XL: Documents Closed in Restored State Open Maximized
Q111281XL5: Can't Define Name with Same Name as a Subroutine
Q111282XL5 Docerr: Shell Function Pathname and Windowstyle Parts
Q111291XL5: Microsoft Excel 5.0 Not Compatible with OS/2 Version 2.0
Q111293XL5: Invalid Number Format May Cause GP Fault
Q111294XL5: Using Multiple Formats Within a Cell Produces GP Fault
Q111562XL5: Opening Workbook in Mail May Hang Microsoft Excel
Q111564XL: Determining Which Items Are Selected in a List Box
Q111728XL5: Cannot Reopen Password-Protected File
Q111899XL: Controls in Dialog Box May "Snap" to Preset Values
Q111900XL5: List in Dialog Box Does Not Reflect Changes Made by Macro
Q111957XL: Area Charts Ignore "Empty Cells Plotted As" Setting
Q111971XL5: Methods Fail When Embedded Chart Is Edited
Q111984XL: GP Fault If Many Line Continuation Characters in Module
Q112027XL5: GP Fault Checking Spelling in Worksheet
Q112100XL: Macro with ROW.HEIGHT() Function Causes GP Fault
Q112101XL: Print Reports Not Using Continuous Page Numbers
Q112290XL5: Bad or Missing WPD File Prevents Proper Page Setup
Q112330XL: 'For Each Item in List' Doesn't Work
Q112507XL5: Message Always Sent from cc:Mail as "Low Priority"
Q112629XL5: Incorrect Use of "Is" Function Causes GP Fault
Q112630XL: OLE Automation Dialog Box Redrawn Incorrectly
Q112631XL5: SendKeys Buffer May Be Overloaded
Q112682XL5 Err Msg: "Call to Undefined Dynalink" During Setup
Q113248XL: Using View Manager Triggers Recalculation
Q113260XL5: GP Fault When Module-Level Variables Exceed 64K Bytes
Q113490XL: Caption Property of Menu Contains Ampersands
Q113631XL: Shell Function Doesn't Accept Built-in Constants
Q113786XL: Protect Method Fails When Module Is Hidden
Q113795XL5: Can't Select Label Attached to Filled Radar Series
Q113855XL5: Error Bars Too Large When Standard Error Used
Q114172XL: Toolbar Button Colors Appear Incorrectly
Q114357XL: In Visual Basic Module, Hide/Unhide Commands on Edit Menu
Q114436XL: Command to Create Add-in File from Visual Basic Module
Q114674XL: Advanced Filter Deactivates AutoFilter
Q115795XL: Output from Plotter Incomplete/Computer Appears to Hang
Q115796Excel: FACT() and Functions Using Factorials Return #NUM!
Q116116XL: Cannot Evaluate 3-D References Using F9 Key
Q116117XL5/XL7: DateValue Function Doesn't Accept Date Literals
Q116185XL5: Long 'Refers To' in Defined Name Causes GP Fault
Q116187XL: Not Prompted to Enter Summary Information
Q116189XL: Can't Add References If Filenames Similar
Q117125XL5: Name Defined Incorrectly If Sheet Name Contains Space
Q117226XL: Button Width Reported as Zero for Toolbar Buttons
Q117410XL: Maximum Page Number Allowed Is 32767
Q117411XL: Strange Value for PageSetup.FirstPageNumber
Q117413Office: Disk 24 Skipped During Typical Installation
Q117434XL: Cancel Button in Summary Info Does Not Cancel Save
Q117597XL: GET.DOCUMENT(68) Always Returns Workbook Name
Q117840XL5 Err Msgs: "Excel Busy..." or "Application Can't Be Found"
Q118402XL5: Secondary Mouse Button "Hangs" ChartWizard
Q118484XL: Formula That Transposes Linked Data
Q118485XL: Macro to Add Labels to Points in an XY (Scatter) Chart
Q118527MOM: Toolbar Buttons Launch Application a Second Time
Q118850XL: Cannot Create Reference to File on LAN Manager for UNIX
Q118923XL: Method to Determine Whether a Year Is a Leap Year
Q119083Excel: MOD() Function Returns #NUM! Error Value
Q119239Excel: How to Sum the N Largest Items in a Range
Q119406MOM: Can't Prevent Customization of MOM Toolbar or Menus
Q119407XL5: Help Topic Missing for Object Library Error
Q119823XL: GP Fault Defining Local Name When "!" in Sheet Name
Q120198XL: How to Select Cells/Ranges Using Visual Basic Procedures
Q120795XL: How to Set the Descriptive Name of an Add-in File
Q120796XL: How to Create a Demand-Loaded Add-in File
Q120801XL5: Can't Use Norton Desktop for Windows FileAssist 3.0
Q120831MOM: Extended Character in Directory Name Causes Error
Q120871XL: AutoSave Command Recorded in Subroutine or Macro
Q120872UNCONF: MSQuery: Bad ODBC.INI File Causes GP Fault
Q121391XL: GP Fault When Saving File Containing 3-D Reference
Q121817XL5: Some OPEN.LINKS() Arguments Not Shown in Function Wizard
Q121821MXL5: Template Filenames Don't Appear in File Open Dialog Box
Q121940XL5: Function Wizard Error When Function Contains Loop
Q122137XL: GP Fault When Info Window Viewed in Print Preview
Q122666XL5: DSUM/DAVERAGE Functions Fail with Computed Criteria
Q123577XL: Problems Linking/Saving Files with Brackets in File Name
Q125761MXL5: Paste Special Dialog Box Different in Version 5.0
Q129434MXL5: Application.Quit in Auto_Open Sub Causes Computer to Hang
Q129508XL: Row/Column Headers Appear on Dialog Sheet
Q132194OPP: Invalid Page Fault When Inserting Map Into Excel
Q134412XL: DefType Statements Change If Workbook Used on New Platform
Q134611XL: MS Excel Hangs When You Set Options for Custom Function
Q134942XL5: XLODBC.XLA Only Available for Intel Platform
Q135242XL7: Maps Pasted into Word Not Updated Correctly
Q135791XL: Changing the Paper Source Using SendKeys
Q135880OFF95: Forcing Office Shortcuts into a Subgroup
Q136092Office: No Network Button in Open and Save As Dialog Boxes
Q136313XL7: Corrected Words May Be Truncated by Spelling Checker
Q136316XL7: (Non-English Version) Can't Open Files If File Has Data Map
Q136727OFF: Cannot Change the Default Folder for Opening Files
Q136886OFF95: "What's New" Window Appears Blank in Windows NT
Q137014XL: Crystal Ball Does Not Work in Windows 95
Q137015XL: Add-ins That Don't Work with 32-bit Versions of MS Excel
Q137103Cannot Run Setup If Installation Source Is Unavailable
Q137527XL: Value of 15-Digit Numbers May Be Changed Unexpectedly
Q138420XL: Cannot Change Bounding Outline (Marquee) Color
Q143452XL97: Excel Hangs When You Programmatically Save a Workbook
Q143458XL97: Cannot Move or Copy Sheet After Last Sheet
Q143460XL97: Overflow Error Occurs When Using Err Object
Q143461XL97: CreateObject and GetObject Work Differently
Q150613OFF97: Microsoft Office 97 Service Release 1 Patch
Q154876XL: Right-Bracket in Text File Name Causes Problems
Q156002OFF97: How Combi Trigger Digit Logic Works in Setup
Q156008XL97: "Reference Is not Valid" Error Clicking Hyperlink
Q156041OFF95: Microsoft Office Binder 7.0 Cannot Open Binder 97 Files
Q156042OFF97: Microsoft Office 97 System Requirements
Q156199OFF97: Clicking "Remove All" During Setup Removes Inbox Icon
Q156264XL97: Document Disappears After Clicking Hyperlink
Q156268OFF97: No Help Text Appears in Status Bar for Menu Items
Q156312OFF97: Page Fault After Using Desktop Themes Control Panel
Q156351OFF97: Cannot Open Shared Folder on Network Server
Q156352OFF97: Setup Adds Information to PATH Variable in Autoexec.bat
Q156353XL97: No Menu Choice to Select All Hyperlinks
Q156419XL97: No WorkGroup Toolbar in Microsoft Excel 97
Q156442XL97: No "Center Across Columns" Toolbar Button
Q156443XL97: Files Increase in Size When Saved in XL97 Format
Q156444OFF97: Service Pack Requirements for Windows NT Workstation
Q156445XL97: New A Functions in Microsoft Excel 97
Q156446XL97: "That Command Cannot Be Used" Inserting Columns or Rows
Q156450XL97: No Info Window in Microsoft Excel 97
Q156452OFF97: Office Programs Require Virtual Memory
Q156455OFF97: "Setup Is Updating Your System" Appears to Hang Setup
Q156542OFF97: Microsoft Office 97 Service Release 1 Enterprise Update
Q156603XL97: Microsoft Excel Inserts a Defined Name in Formula
Q156604XL97: Text Contained in AutoShapes Does Not Rotate
Q156648TRIAL97: "Setup Needs to Verify" Message During Setup
Q156650XL97: Cannot Drag Drawing Objects Between Worksheets
Q156815OFF97: Admin Setup Reports Not Enough Free Space
Q156816TRIAL97: Setup Fails if Folder Name Contains a Percent Sign
Q156817OFF97: Setup Overwrites Office 95 Start Menu Items
Q156818OFF97: Internet Explorer 2.0 Required in Windows NT 3.51
Q156819OFF97: Removing MS Exchange Breaks MS Outlook
Q156835OFF97: Complete Setup Doesn't Install All ODBC Drivers
Q156841XL97: REPT Function Limited to 32,767 Characters
Q156843OFF: Password Lost When Document Saved from Binder
Q156848OFF97: Assistant Appears Twice in Office Assistant Gallery
Q156869XL97: Pasting Entire Column Is Slower than in Earlier Versions
Q156877OFF97: Name and Organization Boxes Blank During Setup
Q156879OFF97: Visual Basic Modules Cannot Be Hidden or Protected
Q156880XL97: Using the MenuBars Method in Microsoft Excel 97
Q156881XL97: Only 1,024 Characters Are Displayed in a Cell
Q156882XL97 Err Msg: "Name Conflicts with Existing Module"
Q156883XL97: "Create Hyperlink Here" Does Not Work in Unsaved File
Q156926XL97: Unusual Behavior When You Use the HYPERLINK Function
Q156927OFF97: Handling Customers with Invalid or Lost Product Keys
Q156941XL97: Forward Button on Web Toolbar May Not Be Available
Q156942XL97: How to Create an Add-in File in Microsoft Excel 97
Q156943XL97: How to Convert an Add-in File into a Workbook
Q156944OFF95: Setup Hangs on NT 4.0 Server With IIS Running
Q156983XL97: Print Titles with Merged Cells Add Columns or Rows
Q156984XL97: Cannot Drag Drawing Objects onto Windows Desktop
Q156985CG3: Error When Using Clip Gallery to Insert a Sound
Q157022OFF97: Setup Fails if Network Share Name Contains a Space
Q157027XL97: Attached Toolbar Is Not Saved in 5.0/95 File Format
Q157093XL97: Text May Print on Top of Drawing Objects
Q157095XL97: Natural Language Formulas Return Error
Q157099XL97: Borders Below Row 65536 Do Not Print
Q157100OFF97: ToolTips Briefly Stop Working
Q157102XL: EnableSelection Property May be Overridden
Q157103XL97: Macro Stops Running When its Workbook Is Closed
Q157104XL97: Errors When Trying to Make Office Assistant Visible
Q157105XL97: Worksheet_Change Does Not Run When Worksheet Sorted
Q157108XL97: Options Not Available in Macro Options Dialog Box
Q157110XL97: Problems When Selecting Error Bars With a Macro
Q157124XL97: Styles("X").Parent Different Than in Earlier Versions
Q157202XL97: Color Palette Looks Different in Microsoft Excel 97
Q157203XL97: Cannot Add Macros to the Tools Menu
Q157204XL97: Odd Behavior Using Format Painter and Merged Cells
Q157306XL97: Len Function Returns Only 1024 Characters in Cell
Q157307OFF97: Back Button in Netscape Navigator Is Not Available
Q157308XL97: Calling RunAutoMacros Method More than Once Fails
Q157309XL97: Errors Appear When Opening Web Query File on FTP Server
Q157320XL97: Macro Cannot Open a File That Has No Extension
Q157346XL97: Code "Behind" Worksheet or Workbook may not Work
Q157348XL97: All Views Listed in Custom Views and Report Manager
Q157349XL97: Can't Access File List and Window List Menu Items
Q157350XL97: Text Property Limited to 1,024 Characters
Q157352XL: Drawing Objects Appear Differently When Saved to 5.0/95
Q157353OFF97: Show Office Toolbars Button May Not Be Available
Q157414OFF97: Cannot Dismiss Office Assistant With Keyboard
Q157482XL97: How to Create Web Query (.iqy) Files
Q157483XL97: Limit of Natural Language Formulas per Worksheet
Q157484XL97: Error When Using Validation Drop-Down List Box
Q157486XL97: Limits of PivotTables in Microsoft Excel 97
Q157488XL97: Using Server Page Fields in PivotTables
Q157495XL: Odd Workbook Behavior After Modification by MS Access
Q157497XL: Saving a File for 5.0/7.0 and MS Excel 97 or MS Excel 98
Q157553Dialog Boxes and UserForms Use Tahoma Font
Q157555XL97: UserControl Property Code Example Doesn't Work Properly
Q157556XL97: Problems When Removing Line from Drawing Object
Q157569XL97: Can't Select Cells When Using Netscape Navigator
Q157609XL97: How to Display a UserForm Whose Name Is in a Variable
Q157610XL97: Problems When AutoFilling Very Large Time Frames
Q157611XL97: Menu Bars and Toolbars Flash When You Close a Workbook
Q157754XL97: Problems When Disabling/Enabling Menus
Q157755XL97: Using "Checked", "Gray", and "Unchecked" in Macros
Q157758XL97: Clicking Cancel Button May Not Dismiss UserForm
Q157763OFF97: Memory Problems When Hyperlinking Between Programs
Q157764OFF97: Timex Wizard Setup Fails Under Windows NT
Q157768XL97: Not All Menu Items Appear for Other Users
Q157769XL97: How to Delete, Restore, and Edit Menu Items Manually
Q157770XL97: Error When Dragging Embedded Chart into Microsoft Word
Q157952XL97: Customize Dialog Stays Behind Toolbars When Clicked
Q157955OFF97: Cannot Change Assistant When Free Disk Space Is Low
Q157956OFF97: Small Business Pack Does Not Work with MS Office 97
Q157957Query97: Redraw Problems in Choose Columns Dialog Box
Q157958XL97: No "Record at Mark" Feature in Microsoft Excel
Q157997TRIAL97: Contents of the Letter Enclosed with Trial97
Q158063XL: Clicking Sheet Tab Deselects Grouped Sheets
Q158065OFF97: Controlling How and When the Office Assistant Appears
Q158069OFF97: Products That Qualify for the Office Upgrade
Q158071XL: Problems With Statistical Functions and Large Numbers
Q158072XL97: Menu Added in Wrong Position on Menu Bar
Q158080XL97: Cannot Paste Array Formula in Its Original Cell
Q158097XL97: File Name in Formula Doesn't Appear Correctly
Q158098OFF97: Setup May Remove Older Components
Q158156XL97: Shadows on Drawing Objects may not Appear Correctly
Q158157OFF97: Find Fast Indexes Special FrontPage Directories
Q158158TRIAL97: Programs Don't Work On or After March 1, 1997
Q158222XL97: ParamArrays are Always Zero-Based
Q158281OFF97 Err Msg: "Setup Error 544"
Q158300XL97: "Cannot Open Specified File" Clicking Hyperlink
Q158330XL97: HYPERLINK Doesn't Work If Second Argument Returns Error
Q158332OFF97: "Best of the Web" Link Fails to Open Internet Site
Q158353XL97: Error When Invalid Characters in Drawing Object Name
Q158355XL97: ParamArray Must Be Declared as an Array of Variant
Q158360XL97: PasteSpecial Method Activates Target Sheet
Q158434XL97: Cannot Make Changes to Some Shortcut Menus
Q158472XL97: No Automatic Type Coercion Between Variable Types
Q158476TRIAL97: Uninstall Fails After Run From Network Server Setup
Q158503OFF97: Setup Switches for Microsoft Office 97
Q158504TRIAL97: "Getting Results Book" Button on OSB Doesn't Work
Q158542CG3: Clip Gallery Takes a Long Time to Start
Q158543XL97: Double-Clicking Workbook in MS Exchange Causes Error
Q158550XL97: Problems Disabling and Enabling Shortcut Menus
Q158632XL97: Limitations for Naming Visual Basic Modules
Q158638XL97: ApplyNames Method May Cause Invalid Page Fault
Q158650OFF97: Error When Using Online Registration
Q158658OFF97: How to Completely Remove Microsoft Office 97
Q158687XL97: Error When Function Contains a Breakpoint
Q158688XL97: Closing UserForm Causes MS Excel to Hang
Q158704OFF97: Disk Space Requirements for Microsoft Office 97
Q158705OFF97: How to Disable the Find Fast Indexer
Q158746XL97: Error When Passing an Array Value Between Macros
Q158747OFF97: Problems with "Provide Feedback with Sound" Option
Q158801XL97: Text Is Truncated in a Text Box with Rounded Corners
Q158875OFF97: .Exd Files Are Created When You Insert Controls
Q158879XL97: ;;; Number Format Fails to Hide Cell Contents
Q158888OFF97: Extra Buttons Appear on Office Shortcut Bar After Setup
Q158889OFF97: Imported EMF Files Are Not Printed Correctly
Q158895XL97: Invalid Page Fault After Closing Last Open Workbook
Q158905XL97: "Bad DLL Calling Convention" When Running a Macro
Q158915OFF97: Remove All Doesn't Remove Shortcut Bar .Tmp Files
Q158996XL97: Excel Opens Without Displaying Workbook
Q158997XL97: Error When Variable Refers to Deleted or Moved Sheet
Q159002XL97: Deleting Sheet and Closing Workbook Causes Crash
Q159157XL97: Convert to MS Access Menu Command May Work Incorrectly
Q159223XL97: Macro Recorder Doesn't Record Some Menu Commands
Q159227XL97: Drawing Objects and AutoShapes Printed Incorrectly
Q159230XL97: Clicking Microsoft Excel on Taskbar Does Not Work
Q159359OFF: How to Rename a Button on the Office Shortcut Bar
Q159374OFF: Clicking Button on OSB Starts a New Session
Q159406OFF97: How to Change a Toolbar Button in the OSB
Q159419XL: DDE Links Break When Changed from Manual to Automatic
Q159446TRIAL97: Illegal Operation Error During Setup
Q159465XL97: "Module Not Found" Error Opening Workbook
Q159472OFF97: "Access Violation" When You Add a Button to the OSB
Q159474XL97: Startup Switches for Microsoft Excel 97
Q159527OFF97: Can't Install Visual FoxPro or Microsoft Office 7.0
Q159572OFF97: Right-Clicking File Causes Error and Computer Stops
Q159723OFF97: Problems Fixed by Service Pack 2 for Windows NT 4.0
Q159729XL97: "255 Characters in Cell" Error when Copying Worksheet
Q159771OFF97: Contents of the Ofread8.txt Readme File
Q159772OFF97: Contents of the Netwrk8.txt Readme File
Q159778OFF97: What Is Included in the Product Box?
Q159803OFF97: How to Install Program Shortcuts to a Folder
Q159818OFF97: Binder Stops Responding Using Binder Page Setup Dialog
Q159825OFF97: Remove All Removes Mail Options from Internet Explorer
Q159832XL97: Inserting Second Trendline into Chart Halts MS Excel
Q159863XL97: Problems When You AutoFormat an Entire Worksheet
Q159922XL97: Using Quit Method May Cause Illegal Operation
Q159938XL97: Structure and Windows Arguments of Protect Method
Q159947XL97: Illegal Operation Unhiding a Row with a Macro
Q159960XL: Drawing Objects Behave Differently When Clicked
Q159964XL: Pointer Is an Hourglass When You Display a Message Box
Q159997XL97: Illegal Operation Closing File When VBE Is Visible
Q160049OFF97: How to Obtain Microsoft Office 97 on Floppy Disks
Q160062OFF97: Convdsn.exe/Msvcirt.dll Error During Setup
Q160200TRIAL97: Error Dragging Workbook into Briefcase
Q160208OFF: How to Rename Toolbars on the Office Shortcut Bar
Q160327XL97: Defined Names Are Case Sensitive in Microsoft Excel 97
Q160462XL97: Auto_Close Macros Run When You Use Application.Quit
Q160489XL97: Menu Editor and Make Add-In Dialog Boxes Cause Error
Q160520XL97: Error Adding or Deleting a Menu Command in a Macro
Q160530OFF97: Networks Supported by Microsoft Office 97
Q160552OFF97: ErrMsg: "Invalid Page Fault in Module Mso97.dll"
Q160600XL97: ScreenUpdating Causes Problems in MS Internet Explorer
Q161122OFF97: Who Supports the Office 97 ValuPack Components?
Q161141OFF97: Invalid Page Fault When Using Office Assistant
Q161218XL97: Copied and Pasted Chart Appears as Gray Rectangle
Q161242OFF97: Setup Program Fails to Run in Maintenance Mode
Q161282XL: NORMSINV Function May Return Incorrect Result
Q161324XL97: Error Using "Mailto:" with FollowHyperlink Method
Q161437OFF97: ErrMsg "Cannot connect to the FTP server"
Q161445OFF97: Errors Appear When Dragging Files into a Briefcase
Q161472OFF97: No Graphics on "Getting Results" Web Page
Q161805OFF97: Error Using Help Method with Microsoft Word 97
Q161928OFF97: Microsoft Office 97 Technology Guarantee Coupon
Q161977OFF97: ODBC Control Panel Fails After Installing IIS 2.0
Q162045XL97: Worksheet Events Don't Occur After Clicking Link
Q162047XL97: Cutting and Pasting Cells Causes Invalid Page Fault
Q162048OFF97: How to Force Installation of All Office Assistants
Q162152XL97: Separate Jobs Sent When Printing/Faxing Multiple Copies
Q162153OFF97: Problems After Returning Computer from Suspended State
Q162154Policy: Setup
Q162173XL97: File Size Increases When You Save the File in 97 Format
Q162295OFF97: ErrMsg: "Bdrintl.dll Was Unable to Register Itself"
Q162323XL97: Contents of the Samples.xls Workbook
Q162380OFF97: Setup Performs Typical Installation by Default
Q162398OFF97: First Aid 97 Causes Invalid Page Fault
Q162407XL: "Cannot Open Add-In" Error When You Run a Macro
Q162474XL97: DFunctions Return Errors When Database Has Too Many Rows
Q162500Invalid Page Fault Opening File in Microsoft Paint
Q162501Policy: Binders
Q162503Policy: Environment-Related Issues
Q162504Policy: File Management Issues
Q162505Policy: Miscellaneous Support Issues
Q162506Policy: Online Registration Wizard
Q162507Policy: Microsoft Office Shortcut Bar
Q162508Policy: Microsoft Office 97 Value Pack
Q162509Policy: Web Find Fast Support
Q162627OFF97: Error Message "Vbe.dll Was Unable to Register Itself"
Q162687Policy: Shared Component Issues
Q162721XL97: VBA Macro Behavior Is Different from Excel 5.0 or 7.0
Q162795OFF97: NIW 2.0 Add Files Dialog Box Displays Only 16 Files
Q162796OFF97: Setup Error 932 After Modifying STF File
Q162914OFF97: How to Configure Setup to Install Extra Clip Art
Q162916OFF97: Office Assistant Doesn't Appear
Q162918OFF97: Text in Setup Billboards Appears Incorrectly
Q162936OFF97: Banyan Vines Patch Available
Q163011XL97: Recorded Macro Contains DrawingObjects Method
Q163125OFF97: "Error Reading CD-ROM"/Blue Screen During Setup
Q163126OFF97: Upgrade Setup Doesn't Recognize Corel 7 CD-ROMs
Q163271XL97: Error Appears or View Not Retained Printing Reports
Q163272OFF97: Can't Use MS Fax After Removing Windows Messaging
Q163274XL97: Error Using Canon MultiPASS C2500 or Bitware Fax Driver
Q163275OFF97: Macro Virus May Be Detected in WWINTL32.DLL
Q163493OFF97: "Insufficient Memory or Disk Space" Setup Error
Q163494Office 4.x: Misccm.c Line Error 447 or 448 During Setup
Q163495XL97: Formats May Not Be Applied to Pasted Merged Cell
Q163496OFF97: How to Read the Bar Code Label on the Package
Q163497XL97: Cannot Stop Macro After Switching to Other Program
Q163678XL Err Msg: "Too Many Different Cell Formats"
Q163679OFF97: Page Numbering Problem in Excel Binder Section
Q163741XL97: Cannot Use xlDisplayShapes with DisplayDrawingObjects
Q163776OFF97: IE Shortcut Installs Correct Version 3.01
Q163858XL97: Cannot Click Once to Create Arrows and Lines
Q163859OFF97: Error Double-Clicking File in 16-bit Mail
Q163937Office: Pros and Cons of Run From Server Installations
Q164024XL97: Printing Problem When Print Titles Contain Borders
Q164163OFF97: Errors Running Setup After "Run From CD" Installation
Q164164XL97: Setting Zoom to 39% or Less Changes Worksheet Appearance
Q164165OFF97: Mci.vbx/Picclip.vbx Error with Kinko's Compact Disc
Q164406XL: How Microsoft Excel Works with Two-Digit Year Numbers
Q164536OFF97: Default Documents Folder Is Not Changed by NIW
Q164681OFF97: Custom Office Assistant Balloon Cannot Be Dismissed
Q164814XL97: Objects or Borders Are Not Printed Correctly
Q164921OFF97: Mso97.dll and Mso7enu.dll Errors When Starting Program
Q165018OFF97: Remove All Breaks WordMail Option in MS Exchange
Q165102XL97: Errors Printing Filled AutoShapes to PostScript Printer
Q165103XL97: Value Returned by VarType for Omitted Arguments Differs
Q165257OFF97: Normal.dot File Is Removed When You Remove Office 97
Q165435XL: "DisplayAlerts" Error Running Macro in MS Internet Explorer
Q165436XL97: Warning Appears When You Use GetObject to Open Workbook
Q165447OFF97: Error Closing Binder when Visual Basic Editor Visible
Q165453OFF97: Small Business Edition Doesn't Include Binder or OSB
Q165779XL97: External Data Range Property Not Saved with Workbook
Q165780XL97: Cannot Record External Data Range Properties
Q165782OFF97: Cannot Use Quiet Mode to Install ValuPack Components
Q165861OFF97: Automation Error After Using RegClean 3.0 or 4.0
Q165983OFF97: Microsoft Office 97 Sounds Don't Work for all Users
Q165985OFF: "Out of Memory" Messages When Running Microsoft Office
Q166125OFF97: Problems with Millennium and Mystique Video Cards
Q166144Visual Basic Code to Activate a Text Box for Editing
Q166173XL97: How to Save Files in Other Formats
Q166273XL: "Can't Find Project or Library" When You Run a Macro
Q166338XL97: Export Method Code Example in Help Is Incorrect
Q166342XL97: Maximum Array Size in Microsoft Excel 97
Q166347XL97: Using the SheetChange Event in Microsoft Excel 97
Q166464XL97: Summary List of Confirmed Bugs in Microsoft Excel 97
Q166652OFF97: Summary List of Confirmed Bugs in Microsoft Office 97
Q166690OFF97: "Lock Aspect Ratio" Checkbox Doesn't Always Work
Q166691XL97: Linked Formula May Return a Maximum of 255 Characters
Q166692XL: Running Multiple Versions of Microsoft Excel
Q166760XL97: Syntax Error Running Macro That Inserts WordArt
Q166763XL97: Defined Names Saved Incorrectly in Lotus 1-2-3 Format
Q166781XL97: Incorrect Printout on HP Color LaserJet PostScript
Q166782OFF97: Error Inserting Wang Image Control into Document
Q166829XL97: Can't Drag Graphics from Internet Explorer
Q166932XL97: List Box Doesn't Work Correctly When Workbook Is Hidden
Q166933XL97: Error Running Macro That Inserts Control into UserForm
Q167076XL97: Text Problems in Controls When Worksheet is Zoomed
Q167077XL97: "Cannot Convert" Error Saving File in Earlier Format
Q167078XL97: Embedded Links to Other Workbooks Cause Error When Exiting
Q167079XL97: "Not Enough Memory" Error Using Linking Formulas
Q167276XL97: Shadows and 3-D Effects Fail to Print Across Page Breaks
Q167277XL97: Referenced Workbooks and Add-Ins Are Automatically Opened
Q167278XL97: Problems Using Inserted Control in Another Window
Q167279XL97: How to Use the ApplyCustomType Method to Format Charts
Q167313XL97: Identical Patterns May Be Printed Differently
Q167385XL97: Error Formatting Cells on WinBook XP5 Laptop Computer
Q167612XL97: Html.xla Add-in May Delete All Files in a Folder
Q167713XL97: Workbooks Saved in Earlier Formats May Open Slowly
Q167723OFF97: Error Using Image Document Object under Windows NT 4.0
Q167724XL97: Number Signs (#) May Appear in Recorded Macros
Q167725XL97: Objects Are Printed Incorrectly on HP DeskJet 1600c
Q167981XL97: Error Viewing Properties of Visual Components Control
Q167985OFF: Running Multiple Versions of Microsoft Office
Q167987OFF97: Behavior of the Edit Menu Item for a Control Differs
Q167988OFF97: Problems Moving Controls Between Programs
Q167989XL97: NLFs that use Restricted Labels Return #VALUE! Error
Q168068OFF97: Files May Be Removed from Server During Installation
Q168199XL97: Workbook Protected/Saved with a Password Is Saved Slowly
Q168200Saving Worksheet in MS Excel 2.1 Format May Change Data
Q168201XL97: Error Messages Appear Clicking Options on Tools Menu
Q168202OFF97: Error in OSB When You Close Windows Explorer Window
Q168203XL97: "Later Version" Error Message Appears Opening a Workbook
Q168362XL97: Page Fault Opening Workbook with a Merged Column
Q168363XL97: Page Fault Copying Shared Formulas and Opening Workbook
Q168364XL97: Charts.Delete Command in Macro May Delete Worksheets
Q168365XL97: Page Fault Displaying Macro Options Dialog Box in Macro
Q168366XL97: Page Fault Pressing ENTER After Clicking Camera Tool
Q168435XL: Maximum Times in Microsoft Excel
Q168436XL97: Can't Tile Windows with Macro If a Window Is Minimized
Q168562XL97: Clicking Undo Last May Cause Error
Q168563XL97: Problems When Using Different Print Quality for Sheets
Q168564XL97: Errors After Copying Worksheet with Auditing Arrows
Q168603XL97: Cannot Show Scenario That Includes Merged Cells
Q168604XL97: Error When You Change List Property of Combo Box
Q168605XL97: Errors If Module Contains Duplicate Subroutine Names
Q168650XL97: "Not Enough Memory" Error Adding Chart to Workbook
Q168651XL97: How to Control the Placement of Objects
Q168754XL97: Error Applying Comment When Worksheets Are Grouped
Q168755XL: Error Sending Workbook to Mail Program
Q168756OFF97: Hang Viewing Properties of MapInfo MapX Control
Q168757XL97: Error Rolling Wheel on Mouse While Editing Formula
Q168949XL97: Visio 4 Drawing Object May Not Be Displayed Correctly
Q168953XL97: Page Fault Adding Shadow to Series in Surface Chart
Q168954OFF97 SBE: How to Find Information on Free Web Hosting Offers
Q168955OFF97: Generic Icons Appear on OSB After RNS Installation
Q168956XL97: "Cannot Change Part of a Merged Cell" Error
Q169100XL97: Error Message Running Recorded Macro That Resizes a Line
Q169101XL: Text Is Cut Off When Cell Uses Bottom Alignment
Q169103XL97: Run-Time Error in Macro Assigned to Control
Q169104XL97: Run-Time Error Using Macro to Add Custom List
Q169105XL97: Error Running Wizard When a Control Is Active
Q169106XL97: Some Worksheet Properties not Preserved
Q169107XL97: BottomRightCell/TopLeftCell Incorrect with Merged Cell
Q169108XL97: Page Fault Printing to Generic / Text Only Printer
Q169349XL97: Incorrect Printer May Be Used When Printing from Macro
Q169350OFF97: Page Fault Occurs Running Macro with FollowHyperlink
Q169351XL97: Objects May Not Appear After Copying Worksheet
Q169352XL97: Some Page Breaks May Not Be Removed in Group Edit Mode
Q169353XL97: Window Vanishes/Stops Responding After Inserting Cut Cells
Q169354XL97: Error Sending Workbook If Mail Program Is Offline
Q169355XL97: Using the MailLogon Method in Microsoft Excel 97
Q169387OFF97: Security Requirements When Using NTFS Partitions
Q169763OFF97: Cannot View Worksheet in Binder After Viewing Outside
Q169765XL97: Error Activating Worksheet That Contains Controls
Q169766XL: Page Fault Occurs Activating Worksheet in Lotus Notes
Q169767XL97: Using NoteText and Comment.Text to Apply Comments
Q169971XL97: Page Fault Editing Formula That Returns #NULL! Error
Q169972XL97: Using VbConstants in Text Strings in MS Excel 97
Q169975OFF97: Accessibility Aids May Not Work with Office Programs
Q169976XL97: Page Fault After Saving Microsoft Excel 4.0 Worksheet
Q169977XL97: All Input Messages Appear in the Same Location
Q170634XL97: Error Using Virus Search Add-In on Alpha-based PC
Q170635XL97: Run-Time Error 9 When Using a Macro to Remove Page Break
Q170636OFF97: Camcorder Movies May Not Work with NeoMagic Video
Q170680XL7: MS Query Doesn't Work After Installing Visual Basic 5.0
Q170683XL97: Print Area with Merged Cells May Be Set Incorrectly
Q170759XL97: Page Fault Creating RealAudio ActiveX Control Object
Q170760XL97: Embedded Chart Changes Size When Copied and Pasted
Q170826XL97: ActiveX Controls May Be Inadvertently Cropped
Q170827XL: Odd Screen Behavior When AutoShape Has Dashed Border
Q170974OFF97: Macro Virus Warning When Inserting MS Excel Workbook
Q171019XL97: Error Creating Circular References Between Instances
Q171021XL97: Cannot Activate a Worksheet While Inserting Control
Q171022MXL: MRU File Names May Appear Incorrectly on File Menu
Q171026XL97: Page Fault Pasting Array Formula Between Workbooks
Q171075XL97: Run-Time Error 438 If Macro Uses ControlFormat Object
Q171076XL97: Error Setting AxisGroup Property of Series Class
Q171216XL97: Error Opening Password-Protected File with Merged Cells
Q171217XL97: "System Error &H80070057" Message Opening Add-In
Q171218XL97: Error Filling Large Numbers of Array Formulas
Q171278XL97: Problems When Macro Opens/Saves Text Files with Dates
Q171279XL97: Number Formats Lost Error Opening HTML File
Q171281XL97: Problems with Arguments of PasteSpecial Method
Q171309XL97: Macro Error When You Use GET.TOOLBAR Command
Q171468XL97: Toolbar Changes May Be Lost When You Upgrade to SR-1
Q171469XL97: Lotus Macro Interpreter Menus May Not Work as Expected
Q171705XL97: Text Copied from Microsoft Word Is Converted into Squares
Q171706XL97: Context-Sensitive Help Not Available for Some Controls
Q171707OFF97: Error Installing Office 97 SBE on Non-DSP Windows 95/98
Q171894XL97: Comment Formatting May Be Lost When You Share a Workbook
Q171898XL97: Defined Names Display #REF! After Clicking Undo
Q171899XL: "Syntax Error in FROM Clause" When Getting External Data
Q171951XL: Error Using Defined Name That Refers to a Constant Value
Q171953XL97: Problems Using ColorIndex to Set Color of Borders
Q172034XL97: Using Microsoft Excel to Save a File to an FTP Site
Q172035XL97: Cells in Protected Worksheet May Be Unmerged
Q172098XL97: Chart in Worksheet Resized After Pasting into Word
Q172114XL: Cannot Use Array of Data Points with Extend Method
Q172241XL97: White Text May Not Be Printed or Appear in Preview
Q172258XL97: Page Fault Running Macro That Adds Chart to Worksheet
Q172259XL97: Error Clicking Pick From List in Cell with Many Characters
Q172260XL97: Page Fault Clicking Sheet Tab When Formula Bar Is Active
Q172261XL97: "Cannot Quit" After Using Visual Basic Editor
Q172262XL: Error Setting Type Property of Trendline with Macro
Q172263XL97: Page Fault Copying Worksheet That Contains a Chart
Q172264XL97: Error Pressing TAB with Transition Navigation Keys Option
Q172320XL: Cannot Use Page Setup Property If No Printers Installed
Q172321XL97: Page Fault When Formatting a Series in a Chart
Q172322XL97: Run-Time Error 40009 When You Run DAO Macro
Q172323XL97: Page Fault When You Use CTRL Key to Run Macro in XLL
Q172355OFF97: STOP HLINK.DLL Error After Installing SR-1
Q172356XL97: Error Opening Workbook That Is Modified By Using DAO
Q172357XL5: Error Using PivotTable in Workbook Saved by MS Excel 97
Q172358XL97: Error Opening Workbook That Contains MS Access Table
Q172411XL97: Visio 4 Drawing Object Disappears After Being Opened
Q172412XL97: Page Fault Setting ProtectGoalSeek Property of Chart
Q172413OFF97: Error Closing MS Word Document Containing Worksheet
Q172461XL97: Error or Chart Disappears When You Open a Lotus WK4 File
Q172499XL97: Error Appears When CopyFromRecordSet Uses Empty Variable
Q172503XL97: How to Link to a Particular Worksheet from a Web Page
Q172504OFF97: Cannot Install Patch If MS Office 97 Is Not Located
Q172542OFF97: Using the Undo Feature with Inserted Objects
Q172543OFF97: Error When Inserting .Exe File into Worksheet in Binder
Q172544XL97: Error Quitting WordPad Document That Contains Worksheet
Q172545XL97: Error When Inserting Portfolio 7.0 Object into Worksheet
Q172587XL: Linked Picture Is Not Updated When Source Data Is Not Open
Q172588XL97: Format Function May Return an Incorrect Date
Q172638XL97: Error Opening Workbook That Contains Very Long Strings
Q172639XL97: Error Activating Chart Not on the Active Worksheet
Q172640OFF97: Workbook Changed by MS Access May Not Be Recalculated
Q172709XL97: Error Saving or Closing Files with Defined Names
Q172753XL97: Error Updating or Modifying Link to DDE Server Program
Q172760XL: Function Using ActiveCell Property Returns Incorrect Result
Q172791XL: Formula References Incorrect After Pressing CTRL+ENTER
Q172857XL97: New Text Box Created When Text Box in Chart Linked to Cell
Q172858OFF97: Error Activating Password-Protected Workbook Object
Q172911XL: Incorrect Result Raising 10 to Very Large/Very Small Power
Q172948XL97: "Not Enough Memory" Opening a Workbook with a Chart
Q172950OFF97: Hyperlink ToolTips in MS Excel Worksheet Stop Working
Q172990XL97: PivotTable Appears Incorrect If Data Contains Merged Cell
Q172995OFF97: List of Fixed Problems in Office 97 for Windows, SR-1
Q172996XL97: List of Fixed Problems in MS Excel 97 for Windows, SR-1
Q172999XL97: Cannot Use Object Box When Multiple Controls Are Selected
Q173043Query97: "Invalid Bracketing" Error Adding Field to MS Query
Q173045OFF97: "Setup Error 168" Installing Office Under Windows NT
Q173047XL97: Printing at Non-Square Resolution Distorts AutoShapes
Q173077XL97: Unexpected Font or Color Formatting Applied to Chart
Q173078OFF97: "That control can only..." Appears Clicking a Control
Q173156XL97: Text Is Cut Off When Printing or Viewing a Worksheet
Q173158OFF97: "I/O Error" Creating New Data Source Under Windows NT
Q173216XL97: Conditional Formatting Unexpectedly Applied to Text
Q173247XL: Value Returned by Format Function May be Different
Q173248XL: Text Box Linked to External Workbook May Not Update
Q173608XL97: Comment Changes Are Not Saved in Shared Workbook
Q173609XL97: Exchange Folder Tool Doesn't Appear After Dragging
Q173612XL97: Error Viewing a Web Page Containing an Excel Workbook
Q173613XL97: Problems Using Office Assistant in Netscape Navigator
Q173614XL97: Resolving Conflicts Unhides Previously Hidden Worksheet
Q173766OFF97: Search Button and Search Box Missing in Office Assistant
Q173821XL97: Changes May Be Lost When Shared Workbook on FTP Server
Q173883OFF97: Missing Parts or Changed Fill When Pasting AutoShapes
Q173923XL: TDIST Function Returns #NUM! If X Argument Is Negative
Q173949XL97: Objects in Chart May Not Appear in Sample Chart
Q173951OFF97: Error Adding/Removing Files After Patching Office 97
Q174084OFF97: SR-1 Patch Fails with Extended Characters in Office Path
Q174143OFF97: Errors After Using Orphan Finder to Remove DLLs
Q174195XL97: Size of Scaled Picture Is Incorrect When Cropped
Q174239XL97: Diagonal Gradient Fill May Not Be Printed Correctly
Q174431OFF97: Problems Occur After Removing MS Internet Explorer 4.0
Q174593OFF97: Advanced Power Management or Find Fast Indexing May Fail
Q174868XL97: How to Obtain the Excel 97 Auto Recalculation Patch
Q175290XL97: #VALUE! Appears When Function Is Recalculated
Q175362XL97: January 1 May Appear as February 1 in a Date
Q175433OFF97: Error Starting "Microsoft Office 97 Starts Here"
Q175569XL97: Fill Is Printed Outside Object on Canon BJC Printers
Q175679XL98: Angled Text May Be Printed Incorrectly
Q175684XL: How to Change Default Font and Font Size in Microsoft Excel
Q175749XL7: Character May Not Be Printed When Text Is Centered in Cell
Q175751XL98: "Unable to Read File" Error Opening Workbook
Q175752XL: Bad Zero Value When You Fill Linear Trend Series
Q175753XL: DATE Function May Return #NUM! Error When Year Is 0-3
Q175851XL: Label Missing from Upper-Left Corner of Consolidation Table
Q175852XL98: Error Saving File That Contains COUNT in WK1 Format
Q175853XL98: Angled Text Is Unreadable or Not Displayed
Q175854XL98: No Option to Display Shortcut Keys in ScreenTips
Q175855XL: No Legend Entries in Surface Chart When Axis Maximum Is 0
Q175861VBE: No ScreenTips in Visual Basic Editor When Balloon Help On
Q175863XL97: Reference Incorrectly Listed as "MISSING" in MS Excel 97
Q175940XL98: No Shortcut Key Appears Next to Chart Item on Format Menu
Q175941XL98: Selecting HLNK in Paste Special Does Nothing
Q176004XL98: Error Browsing Files When Inserting Hyperlink
Q176005XL: Spinner Is Not Printed Exactly as It Appears on the Screen
Q176006XL: Cannot Remove Auditing Arrows by Using Trace Tools
Q176008XL: Name Box Does Not Display Items When No Named Ranges Exist
Q176074XL: Workbook Is Recalculated Many Times When You Save as HTML
Q176155XL: Text Pasted from Text Box Contains Extra Blank Cells
Q176156XL: Error or Page Fault Linking to Workbook or Creating Formula
Q176157XL: Large Text May Overlap Underlines on the Screen
Q176158XL98: Error Message Cut Off Running Code in Immediate Window
Q176159XL98: Print Preview Button Is Unavailable in Print Dialog Box
Q176247XL: Wrap Text Format Causes Text to Move Closer to Top of Cell
Q176248XL98: Type 2 Error Appears After Viewing "About Microsoft Excel"
Q176250XL: Blank Item in Undo/Redo List After Clicking Lock Cell Tool
Q176263XL98: "Automation Error" When You View References Dialog Box
Q176344XL: Text with Shrink To Fit Format May Disappear or Grow
Q176345XL98: Access Keys Do Not Appear in Customize Dialog Box
Q176346XL: Workbook May Not Be Closed When You Click Close Button
Q176403XL98: How to Select Chart Subtype by Using Keyboard
Q176404XL98: Unreadable Characters in Currency Symbol Format List
Q176405OFF98: How to Use Menus and Menu Commands with the Keyboard
Q176412XL98: Drawing Tools Not Recorded into AppleScript Script
Q176413XL98: Error Message Running AppleScript That Clears Print Area
Q176414XL98: "Cannot Paste the Data" Error When Creating Hyperlink
Q176416OFF97: Files Are Not Extracted by CABFILE Viewer
Q176472XL: Text Is Wrapped Incorrectly When Typed in a Cell
Q176473XL: Cannot Move a Line to the Top or Left Side of Worksheet
Q176554XL98: Patterns or Textures Printed Smaller or Larger When Zoomed
Q176555XL: Corners of Double Borders Do Not Meet Around Angled Cell
Q176635XL: Split or Frozen Panes Lost When Saving in Lotus 1-2-3 Format
Q176636OFF: Worksheet Is Not Completely Redrawn After Deleting a Sheet
Q176637XL: Dates May Appear Incorrectly in PivotTable Field Dialog Box
Q176638XL98: Computer Beeps Repeatedly When You Use Print Preview
Q176639XL98: Problems Displaying "About Visual Basic" Dialog Box
Q176640XL: No Macro Virus Warning Appears Opening Protected Workbook
Q176699XL: "Cannot Access" Error Saving File to 'C' on a Macintosh
Q176700XL: Not Prompted to Save Changed Workbook When You Quit
Q176701XL98: Error When Pasting ActiveX Controls or Running a Macro
Q176754XL: Formula Moves or Disappears When You Undelete Column or Row
Q176755XL: Help and History Windows Closed When You Press COMMAND+W
Q176801XL98: Screen Redraw Problem After Error Message in Lookup Wizard
Q176802XL98: Values Incorrect When Formulas Saved in WK3 or WK4 Format
Q176803XL: LibraryPath Includes Trailing Separator on Macintosh
Q176807XL: How to Identify and Remove PLDT/CAR/SGV Macro Viruses
Q176939XL98: Cannot Move Office Assistant Window from Second Monitor
Q176940XL: Error Saving HTML File to a Read-Only Location
Q176941XL98: Error Message Inserting a Locked File into a Module
Q177045XL: "Cannot Jump to 'Application' Because it is Hidden"
Q177046XL98: Selected Cell May Change When You Click AutoSum Tool
Q177047XL98: Recorded AppleScript Cannot Create Embedded Chart
Q177048XL98: Type 1 or Type 2 Error When You Click a Comment
Q177049XL: Page Fault or Type 2 Error Using Highlight Changes in Chart
Q177104OFF98: Pointer (Cursor) Becomes Very Small in Object Browser
Q177108XL: "Compile Error" Running Macro That Changes Margins
Q177109XL98: Now Contact and Now Up-to-Date Menus Don't Work
Q177110XL: Hyperlink Not Restored When You Click Undo Hyperlink
Q177169XL: "Reference Not Valid" Error When You Create PivotTable
Q177170XL: No Alert When Opening File Already Opened by Another User
Q177171XL98: Cannot See Cell Outline If Worksheet Has a Background
Q177172XL: Chart Axis May Be Four Years Early After You Format Scale
Q177191XL: Next Comment and Previous Comment Tools May Not Work
Q177192XL: MS Excel 4.0 Workbooks May Not Appear in Open Dialog Box
Q177193XL98: Multiple Documents Opened or Errors When Excel Starts
Q177194XL: Rich Text Formatting Is Lost When You Use Replace All
Q177195XL98: Cannot Display "About Microsoft Excel" Dialog Box
Q177196XL: Run-Time Error 1004 Appears When Saving File in HTML Format
Q177197XL97: Readme.txt for Date Migration Wizard for MS Excel 97
Q177535XL: Protected Workbook Windows Can Be Collapsed
Q177536OFF98: File Name Spelled Out When Assistant Speaks Alert Text
Q177537XL98: Error Using Dates After 2/7/2040 in Properties Dialog Box
Q177538OFF98: Application Error Message Starting Unbind Program
Q177688XL: IPF/Hang Closing Workbook Containing BeforeClose Macro
Q177691OFF98: Multiple General Tabs Appear in File New Dialog Box
Q177692OFF98: Errors After Moving Library Files Out of Office Folder
Q177693OFF98: Errors Starting Program from Microsoft Office Manager
Q177694OFF98: "<File> is Locked" Error Using Unbind Program
Q177695XL98: Show Clipboard Menu Item Is Missing from Window Menu
Q177827XL98: Button Caption Text May Use a Bold Font
Q177828XL: "Can't Execute Code in Break Mode" When Running Macro
Q177829XL: Arc/Block Arc Adjusted Incorrectly When You Run Macro
Q177830OFF98: Error Inserting Picture File from Floppy Disk
Q177831OFF98: MOM Starts Mail and News Instead of Outlook Express
Q177832OFF97: Personal Web Server Is Not Included in the Value Pack
Q177833OFF97: Support Files Are Not Updated If Project 98 Is Installed
Q177834XL: Public Variables May Be Lost When You Copy a Worksheet
Q177888XL98: Hyperlinks May Be Corrupted When Modified by a Macro
Q177966XL98: Run-Time Error 424 Using File Conversion Wizard
Q177968OFF: "Could Not Find <Program>" When You Click Office Menu
Q177970XL97: Changes Not Saved When Workbook Is Opened in MS Outlook
Q178010OFF98: System and Disk Space Requirements for MS Office 98
Q178011XL98: Dialog Boxes in File Conversion Wizard May Be Confusing
Q178012XL: Category Axis Labels May Appear Twice in Chart
Q178013OFF98: Using Shortcut Keys to Insert Hyperlinks
Q178014OFF98: Button Editor Dialog Box Cannot Be Moved
Q178047XL: Active Cell May Change When You Sort a PivotTable
Q178048XL98: Office Assistant Disappears and Cannot Be Displayed
Q178050Pocket XL: "Error Occurred" Opening File in Invalid Format
Q178174XL98: Cannot Activate Dialog Box When MS Excel Help Is Visible
Q178176XL98: Color Formatting Is Lost When You Save in WK3/FM3 Format
Q178177XL: New Balloon That Contains Picture May Not Be Displayed
Q178179XL: Hyperlink Tooltip Doesn't Appear If Cell Contains Comment
Q178233XL98: Macro Shortcut Key May Be Lost When You Save Workbook
Q178362XL98: Dropdown Lists Collapse When You Release Mouse Button
Q178363XL97: Registry Keys Used by Microsoft Excel 97 for Windows
Q178423XL: AutoCorrect Uses Smart Apostrophes, Not Standard Apostrophes
Q178424XL98: Balloon Help Is Not Available for Some Controls
Q178425XL98: Error Using Defined Name That Refers to a Constant Value
Q178426XL98: Shuts Down Clicking Sheet Tab When Formula Bar Is Active
Q178427XL98: Type 2 Error Copying Worksheet That Contains a Chart
Q178428XL98: Chart Disappears When You Open a Lotus WK4 File
Q178429XL98: How to Link to a Particular Worksheet from a Web Page
Q178430XL98: Formula References Incorrect After Pressing CTRL+RETURN
Q178431XL98: New Text Box Created When Text Box in Chart Linked to Cell
Q178432XL98: PivotTable Appears Incorrect If Data Contains Merged Cells
Q178433XL98: Text Is Cut Off When Printing or Viewing a Worksheet
Q178434XL98: Value Returned by Format Function May be Different
Q178435XL98: #VALUE! Appears When Function Is Recalculated
Q178496XL98: Cannot CONTROL or COMMAND Select Items in List Box
Q178498XL98: Cells in Protected Worksheet May Be Unmerged
Q178501XL98: Chart in Worksheet Resized After Pasting into Word
Q178504XL98: Unexpected Font or Color Formatting Applied to Chart
Q178507OFF98: No User Info or Serial Number in About Office Manager
Q178596XL98: Problems If Virtual Memory Off or Available Memory Low
Q178599XL98: Drawing Objects Don't Snap to Grid When You Press COMMAND
Q178602XL98: Cannot Use Object Box When Multiple Controls Are Selected
Q178603XL98: Comment Changes Are Not Saved in Shared Workbook
Q178606XL: Replacing Text May Change Text to Numbers or Dates
Q178613XL98: Data Maps Are Not Supported in Microsoft Excel 98
Q178614XL: Duplicate Columns in Regression Summary Output Table
Q178672XL98: Comment Formatting May Be Lost When You Share a Workbook
Q178683XL: Some Cells in Worksheet Not Selected Using TAB or SHIFT+TAB
Q178740XL98: Print Area with Merged Cells May Be Set Incorrectly
Q178762XL98: Movie Object Begins Scrolling When You Use Arrow Keys
Q178767XL: Grouping a Field in a PivotTable Changes Other PivotTable
Q178768XL98: All Input Messages Appear in the Same Location
Q178769XL98: Using VbConstants in Text Strings in MS Excel 98
Q178770XL98: BottomRightCell/TopLeftCell Incorrect with Merged Cell
Q178771XL98: "Cannot Change Part of a Merged Cell" Error
Q178772XL98: Cannot Show Scenario That Includes Merged Cells
Q178773XL98: Errors After Copying Worksheet with Auditing Arrows
Q178774XL98: Clicking Undo Last While Checking Spelling May Cause Error
Q178858XL98: Error Filling Large Numbers of Array Formulas
Q178866XL98: ;;; Number Format Fails to Hide Cell Contents
Q178867XL98: Shadows on Drawing Objects May Not Appear Correctly
Q178868XL98: Dates Created with AutoFill Wrong If Time Span Long
Q178869XL98: Error When Using Validation Drop-Down List Box
Q178870XL98: How to Create Web Query Files
Q178871XL98: All Views Listed in Custom Views and Report Manager
Q178872XL98: Odd Behavior Using Format Painter and Merged Cells
Q178873XL98: Borders Below Row 65536 Do Not Print
Q178982XL98: Run-Time Error 57121 If Macro Uses ControlFormat Object
Q178983XL98: MS Excel Hangs or Quits After Saving Excel 4.0 Worksheet
Q178984XL98: Some Page Breaks May Not Be Removed in Group Edit Mode
Q178985XL98: Objects May Not Appear After Copying Worksheet
Q178986XL98: Some Worksheet Properties Not Preserved
Q178987XL98: Run-Time Error Using Macro to Add Custom List
Q178988XL98: Error Message Running Recorded Macro That Resizes a Line
Q178989XL98: How to Control the Placement of Objects
Q178990XL98: HYPERLINK Doesn't Work If Second Argument Returns Error
Q178991XL98: Cannot Insert Natural Language Formulas in a Worksheet
Q179003XL98: Color Palette Looks Different in Microsoft Excel 98
Q179004XL98: Options Not Available in Macro Options Dialog Box
Q179005XL98: Attached Toolbar Is Not Saved in 5.0/95 File Format
Q179006XL98: Extra Columns or Rows Are Included in Print Titles
Q179007XL98: How to Convert an Add-in File into a Workbook
Q179008XL98: How to Create an Add-in File in Microsoft Excel 98
Q179037XL98: Copied and Pasted Chart Appears as Gray Rectangle
Q179040XL98: "Not Enough Memory" When You Apply AutoFormat
Q179044XL: Drawing Objects Appear Differently When Saved to 5.0/95
Q179086XL Help: Value_If_True Argument in IF Function Is Not Optional
Q179215XL98: Excel Quits When You Add Shadow to Series in Surface Chart
Q179296XL98: How to Delete, Restore, and Edit Menu Items Manually
Q179297XL98: Using Server Page Fields in PivotTables
Q179299XL: Note or Comment Doesn't Appear When Cell Is in PivotTable
Q179327XL: Maximum Times Allowed in Microsoft Excel for the Macintosh
Q179328XL98: Text Is Truncated in a Text Box with Rounded Corners
Q179329XL98: "Cannot Open Specified File" Clicking Hyperlink
Q179330XL98: File Name in Formula Doesn't Appear Correctly
Q179331XL98: Limits of PivotTables in Microsoft Excel 98
Q179333XL: Cannot Remove Hyperlink from Merged Cell
Q179458XL: Error Pasting/Cannot Paste Chart into Microsoft Word
Q179459XL98: RETURN and Arrow Keys Don't Work When Movie Is Playing
Q179460OFF98: Search Page Error When You Click Search the Web Tool
Q179461OFF97: "US\English" Error When Installing SR-1 Patch
Q179545XL: EOMONTH Function May Be Incorrect If Date Is in February
Q179583XL: EDATE Function May Be Incorrect If Date Is in February
Q179584XL97: Copied and Pasted Dates Are Changed by 100 Years
Q179645XL98: Cannot Use Keyboard to Select Items in Special List
Q179672OFF98: Type 10 Error and Quit Starting Microsoft Query
Q179678XL: "Check the Spelling of the File" Error Opening File
Q179679XL98: "Not Enough Memory" Error Adding Chart to Workbook
Q179683XL98: Cannot Insert or Activate Embedded MS PowerPoint Object
Q179684OFF98: Fonts Appear in the Trash After Installing Office 98
Q179685XL98: Playing Movie Object Appears in Other Worksheets
Q179687XL: Error Message Clicking Undo Refresh Data on the Edit Menu
Q179804XL: References Missing Moving Files from Windows to Macintosh
Q179805OFF98: MS Preference Panels Folder Location and Contents
Q179806XL: Text Is Truncated in Text Box on Chart in Worksheet
Q179848XL98: Command Underlines Not Available in Some Dialog Boxes
Q179998OFF98: File Is Not Opened When Double-Clicked
Q179999XL98: Cannot Save to Floppy Disk or Network Disk Drive
Q180098XL2000: VBA Macro Behavior Is Different from Excel 5.0 or 7.0
Q180158XL: DATE Function Behaves Differently in Microsoft Excel 97/98
Q180159XL: Dates Inserted by Recorded Macro May Be in Wrong Century
Q180162XL: The 1900 Date System vs. the 1904 Date System
Q180262XL98: Basic Files and Class Files Not Listed in Insert Dialog
Q180263XL98: Chart Objects List Box Displays Only 200 Series
Q180264XL98: Cannot Insert Locked, Read-Only, or Hidden Files
Q180274OFF98: "Default Location" Error Running Value Pack Installer
Q180277XL98: Natural Language Formulas Return Error
Q180278XL98: Only 1,024 Characters Are Displayed in a Cell
Q180353XL98: Visual Basic Editor Appears When You Display UserForm
Q180354XL: Run-Time Error 1004 Setting Focus to Dialog Sheet
Q180448XL98: OK Button in Message Box Is Right-Aligned or Centered
Q180449XL98: Toolbar Is Not Docked When You Double-Click Its Title Bar
Q180450XL98: Template Wizard Allows You to Save in Only One Format
Q180451OFF98: Errors When Inserting Workbook into MS Word Document
Q180518XL: Cannot Add Error Bars to Chart That Contains Many Series
Q180519XL98: Templates, Excel 2.2 Worksheets not Displayed in Find File
Q180521OFF98: System and Disk Space Requirements for MS Office 98 Gold
Q180612XL98: "Not Enough Memory" Saving Workbook in 5.0/95 Format
Q180613XL98: AppleScript Error Selecting Range on Another Worksheet
Q180614XL: Workbooks in Startup Folder Are Not Scanned for Macros
Q180617XL98: Hard Disk Name Appears in Formula or Defined Name
Q180697XL98: New Toolbar Appears to Have No Name
Q180698XL: Cannot Select Logo When Using Additional Templates
Q180699XL: Deactivate Macro Doesn't Run When You Open HTML Document
Q180700XL: Hyperlinks Are Removed or Are Wrong After You Sort Them
Q180855XL: Properties Window Is Blank When Embedded Chart Selected
Q180861XL98: Macro Error Message Appears Behind MS Excel 5.0 Dialog
Q180952XL: Wrong Date Returned When You Enter Month and Digits
Q181191OFF98: "Could Not Find Application" Error When Opening File
Q181192XL98: Unknown Printer Error When Creating Chart Sheet
Q181194XL98: Wrong Date Returned When You Enter Month and Digits
Q181195OFF98: Locals Window, Watch Window, and Watches Not Available
Q181196OFF98: Cannot Customize Toolbars or Menu Bar in VB Editor
Q181197OFF98: Cannot Customize Toolbox in the Visual Basic Editor
Q181198OFF98: Cannot Export Modules, Class Modules, or UserForms
Q181200XL97: Printer Unavailable Error on Print or Page Setup
Q181284XL98: "Cannot Convert" Error Saving File in Earlier Format
Q181285XL98: Maximum Array Size in Microsoft Excel 98
Q181286XL98: External Data Range Property Not Saved with Workbook
Q181287XL98: "Error in Parameter 1" When Working with PivotTable
Q181369XL98: Linked Formula May Return a Maximum of 255 Characters
Q181370XL: Excel Incorrectly Assumes 1900 Is a Leap Year
Q181464XL98: Referenced Workbooks and Add-Ins Are Automatically Opened
Q181465XL98: "Not Enough Memory" Error Using Linking Formulas
Q181466XL98: Error Running Macro That Inserts Control into UserForm
Q181467XL98: Defined Names Saved Incorrectly in Lotus 1-2-3 Format
Q181468XL98: Syntax Error Running Macro That Inserts WordArt
Q181469OFF98: "Lock Aspect Ratio" Checkbox Doesn't Always Work
Q181470XL98: Cannot Click Once to Create Arrows and Lines
Q181482XL98: Setting Zoom to 39% or Less Changes Worksheet
Q181508OFF98: Web Help Menu Items and Hyperlinks Do Not Work
Q181565XL98: Shadows and 3-D Effects Fail to Print Across Page Breaks
Q181566XL98: Formats May Not Be Applied to Pasted Merged Cell
Q181567XL98: Unusual Behavior When You Use the HYPERLINK Function
Q181569XL98: Number Signs (#) May Appear in Recorded Macros
Q181570XL98: Pasting Entire Column Is Slower Than in Earlier Versions
Q181571OFF98: Using the Default Save Files in the Value Pack
Q181572OFF98: Mac OS System Updates That Are Included in the Value Pack
Q181573OFF98: How to Install Additional Assistants from the Value Pack
Q181574OFF98: MS Excel Type Libraries for Foreign Language Macros
Q181575OFF98: How to Install and Use Bookshelf Integration
Q181576OFF98: Microsoft Office Manager Is Not Always Installed
Q181657XL98: Text Contained in AutoShapes Does Not Rotate
Q181704XL98: "Create Hyperlink Here" Does Not Work in Unsaved File
Q181705XL98: REPT Function Is Limited to 32,767 Characters
Q181706XL98: Microsoft Excel Inserts a Defined Name in Formula
Q181707XL98: No Info Window in Microsoft Excel 98 Macintosh Edition
Q181708XL98: "That Command Cannot Be Used" Inserting Columns or Rows
Q181709XL98: New A Functions in Microsoft Excel 98 Macintosh Edition
Q181710XL98: No "Center Across Columns" Toolbar Button
Q181711XL98: "Reference Is Not Valid" Error When You Click a Hyperlink
Q181728OFF97: File Opened Normally When You Click "Open Read-Only"
Q182135XL: "Can't Find Project or Library" When You Run a Macro
Q182136XL98: Error Applying Comment When Worksheets Are Grouped
Q182160XL98: Structure and Windows Arguments of Protect Method
Q182161XL98: Menu Editor and Make Add-in Dialog Boxes Cause Error
Q182162XL98: Type 2 Error Running Macro That Adds Chart to Worksheet
Q182163XL98: "Cannot Quit" After Using Visual Basic Editor
Q182238XL98: Limitations for Naming Visual Basic Modules
Q182239XL98: Error When Passing an Array Value Between Macros
Q182240XL98: Macro Recorder Doesn't Record Some Menu Commands
Q182241XL98: Auto_Close Macros Run When You Use Application.Quit
Q182242XL98: Cannot Use Array of Data Points with Extend Method
Q182243XL98: Cannot Use Page Setup Property If No Printers Installed
Q182244XL98: Format Function May Return an Incorrect Date
Q182295XL98: Cannot Move or Copy Sheet After Last Sheet
Q182296XL98: Overflow Error Occurs When Using Err Object
Q182297XL98: No Menu Choice to Select All Hyperlinks
Q182298XL98: Drawing Objects Behave Differently When Clicked
Q182299XL98: Error Adding or Deleting a Menu Command in a Macro
Q182300XL98: "Not Enough Memory" Opening a Workbook with a Chart
Q182408XL98: Macro Stops Running When its Workbook Is Closed
Q182409XL98: Cannot Add Macros to the Tools Menu
Q182410XL98: Calling RunAutoMacros Method More than Once Fails
Q182411XL98: Displaying a UserForm with a Name That Is in a Variable
Q182412XL98: No "Record at Mark" Feature in Microsoft Excel
Q182480XL98: Styles("X").Parent Different Than in Earlier Versions
Q182481XL98: Len Function Returns Only 255 Characters in Cell
Q182482XL98: Code "Behind" Worksheet or Workbook may not Work
Q182483XL98: Text Property Is Limited to 255 Characters
Q182645XL98: Problems When Disabling/Enabling Menus
Q182646XL98: Cannot Paste Array Formula in Its Original Cell
Q182647XL98: ParamArrays Are Always Zero-Based
Q182648XL98: Error with Invalid Characters in Drawing Object Name
Q182649XL98: ParamArray Must Be Declared as an Array of Variant
Q182650XL98: No Automatic Type Coercion Between Variable Types
Q182701XL98: Using the SheetChange Event in Microsoft Excel 98
Q182717XL98: Cannot Make Changes to Some Shortcut Menus
Q182718XL98: Problems Disabling and Enabling Shortcut Menus
Q182719XL98: Warning Appears When You Use GetObject to Open Workbook
Q182766XL: Date Inserted by Recorded Macro May Be in Wrong Century
Q182941XL98: Error Setting AxisGroup Property of Series Class
Q182968OFF97: "Unknown User" After Installing from Network Server
Q183017XL98: Problems When Selecting Error Bars with a Macro
Q183018XL98: Clicking Cancel Button May Not Dismiss UserForm
Q183019XL98: "255 Characters in Cell" Error When Copying Worksheet
Q183020XL98: Defined Names Are Case Sensitive in Microsoft Excel 98
Q183022XL98: Problems Using ColorIndex to Set Color of Borders
Q183132XL98 Err Msg: "Name Conflicts with Existing Module"
Q183133XL98: Worksheet_Change Does Not Run When Worksheet Is Sorted
Q183134XL98: Worksheet Events Don't Occur After Clicking Link
Q183135XL98: Problems with Arguments of PasteSpecial Method
Q183221XL98: Problems When Removing Line from Drawing Object
Q183222XL98: Menu Bars and Toolbars Flash When You Close a Workbook
Q183279OFF98: Using the Undo Feature with Inserted Objects
Q183280OFF98: How to Read the Bar Code Label on the Package
Q183281OFF98: Cannot Dismiss Office Assistant with the Keyboard
Q183319OFF97: Unable to Open Offcln97.opc When Running Upgrade Wizard
Q183381XL98: Workbooks Saved in Earlier Formats May Open Slowly
Q183383XL98: How to Use the ApplyCustomType Method to Format Charts
Q183384XL98: Error Appears When You Change List Property of Combo Box
Q183424OFF98: Search Button and Search Box Are Missing in Office
Q183425OFF98: No Help Text Appears in Status Bar for Menu Items
Q183472XL98: UserControl Property Code Example Doesn't Work
Q183534OFF98: Visual Basic Modules Cannot Be Hidden or Protected
Q183539XL98: CreateObject and GetObject Work Differently
Q183540XL98: Using the MenuBars Method in Microsoft Excel 98
Q183541XL98: VBA Macro Behavior Is Different from Excel 5.0
Q183626XL: How the DateSerial Function Works with Year Arguments
Q183797XL98: Using NoteText and Comment.Text to Apply Comments
Q183815XL: Custom Date Appears or Date Is Missing in AutoFilter List
Q183816XL98: Custom Date Appears or Date Is Missing in AutoFilter List
Q183913XL98: Charts.Delete Command in Macro May Delete Worksheets
Q183932OFF97: Removing Getting Results, VIM, Binder from RFS Install
Q183985OFF97: Office Assistant Window Appears Off the Screen
Q184083OFF97: SR-1 Patch May Not Work Under Microsoft Windows 98
Q184156OFF97 SR-1: Files Listed in Netwrk8.txt Are Missing
Q184282OFF97: Workbook_Open/Auto_Open Macros Are Run Twice in Binder
Q184292OFF98: "No Installation Was Necessary" Installing Templates
Q184368OFF98: Custom Office Assistant Balloon Cannot Be Dismissed
Q184446OFF98: "No Program Is Registered" Error Clicking Hyperlink
Q184521XL: IsDate Function Incorrectly Identifies Some Expressions
Q184522XL98: IsDate Function Incorrectly Identifies Some Expressions
Q184523XL98: "Cannot Insert Object" When Inserting Text File as Object
Q184628OFF98: Installing Office into a Desktop Printer Is Not Supported
Q184729XL98: Help Windows Are Closed When You Close About Excel Dialog
Q184964XL: Two-Digit Years Don't Follow Windows 98 Regional Settings
Q185099OFF98: Blank Dialog Box When You Click Hyperlink
Q185100XL97: "The Disk Is Full" Error Copying Very Large Worksheet
Q185101XL: Information About Known Macro Viruses in Microsoft Excel
Q185158XL97: Borders Removed When You Remove Hyperlink from a Cell
Q185159XL98: Borders Removed When You Remove Hyperlink from a Cell
Q185234OFF98: Unbind Changes Extended Characters in Section Name
Q185235XL98: Special Characters Saved Incorrectly in Lotus File Format
Q185236XL98: Inserted Background Does Not Appear in Worksheet
Q185278OFF98: Using Quit Finder on the MOM Menu
Q185279OFF97: SR-1 Patch May Fail to Update Word 97 in OEM Versions
Q185360OFF98: Spaces in Hyperlinks Replaced with String "%20"
Q185754OFF98: Dates After 2/7/2040 Are Not Accepted in Advanced Search
Q186028OFF97: Crystal Reports Not Available in Office Resource Kit 97
Q186261OFF97: Two-Digit Years in Properties Dialog in 20th Century
Q186369OFF97: Large Increase in Document File Size After Inserting JPEG
Q187219Installing and Using "Teaching and Learning with Microsoft"
Q188080OFF97: Installing IE 3.02a and Ie302y2k.exe Included in SR-2
Q188081OFF97: Support for the New Euro Currency Symbol
Q188777OFF97: Cannot Find Hyphenation File After Removing Publisher
Q189126Microsoft's Policy Regarding Missing or Invalid Passwords
Q189908XL: Dates Truncated When You Save Worksheet as PRN File
Q189909XL97: Day and Month Switched When Date Copied by Macro
Q190633XL98: Working with Time Periods That Exceed 24 Hours
Q190831XL97: Error 2015 or Type Mismatch Using Evaluate with Dates
Q191115XL98: ShowDataForm Method Fails If Data Can't Be Found
Q191122XL98: No Direct Visual Basic Equivalent for SOUND.PLAY()
Q191154XL98: Macro Cannot Scroll Chart Sheet
Q191161XL98: Error Getting the Value of a Name in Visual Basic
Q191280XL98: Row/Column Headers Appear on Dialog Sheet
Q191968XL98: Area Charts Ignore "Empty Cells Plotted As" Setting
Q191976XL98: Chart Series May Not Be Printed in Black and White
Q192278XL98: AutoSave Command Recorded in Subroutine or Macro
Q192282XL98: Formula That Transposes Linked Data
Q192368XL98: Problems Linking/Saving Files with Brackets in File Name
Q192760XL97: Readme.txt for Microsoft Excel 97 Date Watch Wizard
Q192770OFF97: Contents of the Read_SR2.txt File on the SR-2 Patch CD
Q192816OFF97: SR-2 Patch Fails Even Though SR-1 Has Been Installed
Q192874OFF97: An Overview of Microsoft Office 97 SR-2
Q192995OFF97: How to Install ValuPack Components Updated for SR-2
Q193290OFF97: SR-2 Patch May Fail to Update Admin Installation
Q193565OFF97: SR-2 Patch Can't Update Admin Install Without Bookshelf
Q193650XL97: Error Message: Invalid Data Format
Q193723XL98: Determining Which Items Are Selected in a List Box
Q193821XL98: Using "Most Recently Used" Category for Functions
Q193822XL98: Days of the Week Before March 1, 1900, Are Incorrect
Q193857OFF97: SR-2 Patch Fails If Files Are Read-Only
Q194377OFF97: Overview of the Updated Microsoft Office 97 SR-2 Patch
Q194581OFF97: Err Msg: SR-2 Patch Cannot Be Applied to Your Computer
Q197604OFF97: ErrMsg: "Word Cannot Find the Thesaurus File Msth32.dll"
Q205548XL2000: Using A Functions in Microsoft Excel 2000
Q211503XL2000: "Cannot Open Specified File" Clicking Hyperlink
Q211552XL2000: Attached Toolbar Is Not Saved in 5.0/95 File Format
Q211689XL2000: New Text Box Created When Chart Text Box Linked to Cell
Q211821XL2000: "Cannot Change Part of a Merged Cell" Error
Q211835XL2000: How to Control the Placement of Objects
Q212022XL2000: No "Center Across Columns" Toolbar Button
Q213516XL2000: Cannot Use Page Setup Property If No Printers Installed
Q213524XL2000: "Can't Find Project or Library" When You Run a Macro
Q213587XL2000: Cannot Add Macros to the Tools Menu
Q213606XL2000: Excel Hangs When You Programmatically Save a Workbook
Q214757OFF97: Forms 2.0 (Fm20*.dll) ActiveX Control Security Fix
Q217027OFF95: How to Download and Install the Year 2000 Update
Q217666OFF2000: Error 1327 Invalid Drive During Office Installation
Q217883OFF2000: System Requirements for Office
Q222180OFF97: Unique Identifiers and Microsoft Office 97 Documents
Q222181OFF97: Readme.txt for Office 97 Unique Identifier Removal Tool
Q222184OFF95: Readme.txt for Office 95 Year 2000 Update
Q223396OFF97: How to Minimize Metadata in Office Documents
Q223789XL97: How to Minimize Metadata in Excel Workbooks
Q223790WD97: How to Minimize Metadata in Word Documents
Q223793PPT97: How to Minimize Metadata in PowerPoint Presentations
Q230848OFF2000: Numbering Scheme for Product Code GUIDs
Q230887OFF2000: Crash Deleting ActiveX Conferencing Object or UserForm
Q231430OFF2000: How to Reset Office Registry Settings to Their Defaults
Q232030OFF2000: How to Fulfill the Microsoft Office Technology Guarante
Q232866OFF2000: Pasting Cells May Paste Entire Workbook
Q232967OFF: How to Obtain the Network Installation Wizard
Q233537OFF97: Year 2000 Related Problems Corrected in Office 97 SR-2
Q234688OFF2000: Web Publishing Wizard Files Not Found During Setup
Q235603OFF2000: How to Download and Install the Macedonian Update
Q235662OFF2000: Internal Error 2344 When You Run Office 2000 Setup
Q236351OFF2000: Err Msg: Prerelease Expiration Notice. This Beta...
Q236437OFF2000: ErrMsg: "Internal Error 2351" or "Internal Error 2355"
Q237361WD2000: How to Minimize Metadata in Microsoft Word Documents
Q238417OFF2000: Spaces in Quicken 98 Numbers After Office 2000 Install
Q244593OFF97: Version Checker May Report Incorrect Version of Office 97
Q245013OFF2000: Product Key That Works in OFF2000 May Fail in SR-1
Q245025OFF2000: How to Obtain and Install Microsoft Office 2000 SR-1
Q245755OFF2000: Show Office Toolbars Button May Not Be Available
Q253768OFF2000: "Error 1706..." / "Installation Ended Prematurely..."
Q255499OFF2000: Why Office 2000 SR-1 Update Requires the Office CDs
Q327074OL2000: The Wrong Message Is Deleted When You Use the Microsoft Outlook View Control


Q87987: Excel Err Msg: Margins Do Not Fit Page Size

OK, since I get about one request a week for the contents of this article, which is no longer available on the Microsoft Support web site, I am posting the complete text of the article here. You're welcome in advance. :-)

Excel Err Msg: Margins Do Not Fit Page Size [arxlproj]
ID: Q87987 CREATED: 13-AUG-1992 MODIFIED: 19-JUN-1998

----------------------------------------------------------------------
The information in this article applies to:

- Microsoft Excel for Windows, versions 3.0, 4.0
----------------------------------------------------------------------

SUMMARY
=======

Under certain conditions, Microsoft Excel displays the error message, "Margins do not fit page size" even when the margin settings are appropriate for the selected paper size and page orientation. This happens when the new margin settings are inappropriate for the paper size and page orientation settings that were in effect when you opened the Page Setup dialog box. This may also occur if you have a corrupted printer driver.

MORE INFORMATION
================

Microsoft Excel updates your margin settings before updating your paper size and orientation settings. As a result, when you change the paper size or page orientation and then choose the OK button, Microsoft Excel checks your margin settings against the old paper size and page orientation settings. Microsoft Excel returns the error if your new margin settings aren't appropriate for the old paper size and page orientation settings.

Workaround #1
-------------

Since the margin information is saved to the worksheet itself, you can copy the problem sheet onto a new worksheet. The new worksheet will contain the default page setup settings and should not exhibit the problem.

Workaround #2
-------------

The workaround is to close the Page Setup dialog box after making changes to paper size or page orientation and before making changes to margins. This is only necessary if you are changing margins as well as paper size or orientation.

For example:

1. From the File menu, choose Page Setup.

2. Make any changes to paper size and page orientation.

3. Choose the OK button.

4. From the File menu, choose Page Setup again.

5. Make your margin changes.

6. Choose the OK button.

By closing the Page Setup dialog box between these operations you ensure that Microsoft Excel checks your new margins against the paper size and page orientation you are currently using.

If these workarounds do not fix the problem, you should try to reinstall the printer driver.

REFERENCES
==========

"Microsoft Excel User's Guide 1," version 4.0, pages 530-531, 541 "Microsoft Excel User's Guide," version 3.0, pages 529-531, 541

KBCategory: kberrmsg
KBSubcategory:

Additional reference words: 3.0 3.00 4.0 4.00

Click
here to return to http://www.clayjohanson.com/.