Excel Documentation

• Articles
  • Q162321 - Excel articles Available by E-Mail: Functionality
  • Q162040 - Excel Articles Available by E-Mail: User Interface
• Charts
  • Q151521 - Add totals stacked column chart
  • Q115073 - Adding a second X axis
  • Q214292 - Adding series to XY scatter chart
  • Q115341 - Column Charts May Not Show All Data Labels
  • Q213930 - Create a bell curve chart
  • Q213929 - Create a single stacked column or bar chart
  • Q213928 - Create two pie charts in one
  • Q152381 - Creating a Chart with Stacked and Unstacked Columns
  • Q77241 - Creating Charts with Multiple Groups of Stacked Bars
  • Q214240 - Glossary of charting terminology
  • Q213958 - How to Add Text to the X or Y Axis on a Chart
  • Q213881 - How to Change Chart Type of Series in Combination Chart [XL2000]
  • Q214011 - How to Create a Column Chart with Two Y Axes [XL2000]
  • Q259625 - Invalid External Reference Error When Creating Chart
  • Q271202 - Lines between data points not appearing in excel
  • Q118485 - Macro to Add labels to Points in an XY (Scatter)
  • Q213750 - Macro to Add labels to Points in an XY (Scatter)
  • Q211960 - Setting default and user-defined chart types
  • Q214040 - Text Labels for XY Scatter Charts
  • Q116057 - Trendlines Unavailable for Area Chart Type
  • Q156978 - XL97: Chart Data Table Does Not Display All Data Points
  • Q161731 - XL97: Chart Display Options Change According to Page Setup
  • Q156890 - XL97: Charts Open Slower than in Earlier Versions
  • Q155205 - XL97: No Data Table Option With Some Charts
• Configuration
  • Q290138 - Enable Microsoft Office XP Shortcut Bar to Run Automatically
  • Q320531 - Fill Color and Fill Pattern Are Not Displayed
  • Q183757 - How to Change the Alternate Startup Folder
  • Q211922 - How to Modify the Number of Undo Levels [XL2000]
  • Q218861 - Running Multiple Versions of Microsoft Office
  • Q65416 - Solver Company www.frontsys.com
  • Q211481 - Startup Switches for Microsoft Excel 2000
  • Q101454 - Unable to open from email
• Conversion
  • Q291319 - Convert Quatro Pro (WB3) files to Excel
• CTFMon
  • Q282599 - What Is CTFMON and What Does It Do?
• Data & Formats
  • Q124739 - Can't Use Find/Replace on Text with Leading Apostrophe
  • Q263580 - How to Change the Case of Text
  • Q104035 - How to Insert Special Characters (Excel Most Frequently Asked Questions)
  • Q303384 - How to Parse Names Without Data Text To Columns (see also Q214261)
  • Q269370 - Last Digits Changed to Zeroes When You Type Long Numbers
  • Q80005 - Placing a Carriage Return (in a Cell)
  • Q80478 - Rounding Up or Down to a Defined Precision Limit (Ceiling, Roundup, Rounddown)
• Dates & Times
  • Q214083 - Working with Time Periods That Exceed 24 Hours
• Error
  • Q230895 - "Installation Ended Prematurely Because of an Error"
  • Q302375 - Clip Organizer Cannot Complete the Operation
  • Q236427 - Error 1402 Running Office XP Setup
  • Q302853 - Error 1402 Running Office XP Setup
  • Q297834 - Error 1706 Using CD to Repair Office or Install Feature
  • Q298021 - Error 1706 Using CD to Repair Office or Install Feature
  • Q310777 - Error 1706 Using CD to Repair Office or Install Feature
  • Q190040 - Installing Win 98 to New Folder to Tshoot Office Problems
  • Q290234 - Internal Error 2894 During Office Installation
  • Q164921 - Mso97.dll and Mso7enu.dll Errors When Starting Program
  • Q300912 - Program Hangs and Errors Appear with Voodoo3 Driver
  • Q297920 - Setup Appears to Hang Followed by Internal Errors
  • Q163277 - Setup Error 168 or "Tahoma Font Is Not Present" Error
  • Q140900 - Setup Error 797 Appears When You Run Office Setup
  • Q218873 - Troubleshooting Office Kernel32.dll Errors Under Win 95
  • Q218853 - Troubleshooting Office Kernel32.dll Errors Under Win 98
  • Q245050 - Troubleshooting Office Kernel32.dll Errors Under Windows
  • Q302887 - Using help in Office XP returns script error
  • Q305495 - "Fatal Exception OE" Err Msg Running Office Setup
  • Q238319 - "Installation ended prematurely" Error When Setup Cannot Find the IE5 Folder
  • Q253912 - "Out of Memory" Errors with Large Amounts of RAM Installed
  • Q141373 - Access can't start because there is no license for it on this …
  • Q191224 - Access can't start because there is no license for it on this …
  • Q191224 - Access can't start because there is no license for it on this …
  • Q303048 - Activation Wizard Hangs
  • Q318840 - An error occurred while attempting to create the directory …
  • Q236299 - An Error Occurred While Loading 'Sheet1111111111111...
  • Q306986 - An internal error has occurred -- office setup
  • Q306986 - An internal error has occurred -- office setup
  • Q306986 - An internal error has occurred -- office setup
  • Q306986 - An internal error has occurred -- office setup
  • Q236456 - Another installation is in progress -- Off2000
  • Q292503 - Applications Hang when Activating
  • Q314810 - Cannot copy cab file Office1.cab -- error 1335
  • Q314810 - Cannot copy office1.cab -- may have to do with shared video memory
  • Q324845 - cannot create directory (directory name) - a file with this name…
  • Q291846 - Cannot install SR-1 for office 2000
  • Q291846 - Cannot install SR-1 for office 2000
  • Q107077 - Can't Reference Global Name of First Sheet
  • Q162209 - Clicking on the toolbar brings up the wrong menu
  • Q307410 - Compile error in hidden module -- excel / word performed error
  • Q108001 - Copying a Sheet with Identical Local and Global Names
  • Q232143 - could not create key
  • Q235242 - Could not update the ini file Win.ini -- Off2000 -- error 1913
  • Q315636 - Date is set incorrectly -- error 2503 or 2502
  • Q315636 - Date is set incorrectly -- error 2503 or 2502
  • Q45758 - Descriptions of error values returned by functions
  • Q293806 - Enter Valid Product Key to Use This Product...
  • Q236437 - Err Msg: "Internal Error 2351" or "Internal Error 2355"
  • Q236437 - Err Msg: "Internal Error 2351" or "Internal Error 2355"
  • Q236437 - Err Msg: "Internal Error 2351" or "Internal Error 2355"
  • Q298029 - ErrMsg Log File Always Contains "Internal Error 2898"
  • Q229819 - ErrMsg When You Install or Upgrade Windows Installer
  • Q300832 - Error 1316. Setup Cannot Read from .Msi File
  • Q259554 - Error 1328 when you apply office 2k SR-1
  • Q315152 - Error 1328 when you apply office xp SP-1
  • Q299066 - Error 1904 and Error 1919 When You Try to Repair Office
  • Q237294 - Error 1904 During Office 2000 Setup
  • Q302399 - Error 2349 -- Copy resumed with different info
  • Q284250 - Error 2355. Setup Cannot Access a File Cabinet
  • Q301671 - Error 2737. An Internal Error Has Occurred
  • Q314437 - Error 2744 -- an internal error has occurred
  • Q321487 - Error 2744 -- an internal error has occurred
  • Q254869 - Error 2932 applyingthe SR-1 update on windows 2000
  • Q251274 - Error Attempting to Install Program Using Win Installer -- NT4
  • Q251274 - Error Attempting to Install Program Using Win Installer -- NT4
  • Q290158 - Error Codes and Error Messages for Windows Installer
  • Q299066 - Error configuring ODBC data source
  • Q299611 - Error configuring ODBC data source
  • Q292448 - Error configuring ODBC data source -- not found in registry -- 6
  • Q271908 - Error configuring ODBC data source -- Visual FoxPro
  • Q26348 - Error in Formula with More Than Seven Embedded IFs
  • Q299611 - Error installing ODBC driver
  • Q304501 - Error Message When You Upgrade: Error 2735 OPC Remove
  • Q299774 - Error Message: Setup Was Terminated Due to an Error
  • Q217560 - Error opening installation log file -- verify that the specified log …
  • Q248263 - Error reading from file
  • Q251274 - Error When Attempting to Install Program Using Windows Installer
  • Q212008 - Error When Sorting a Range Containing Merged Cells
  • Q177248 - Errors Opening Workbook from Windows Explorer [XL97]
  • Q107468 - Errors When Worksheet Name Contains Apostrophe
  • Q306604 - Excel 2000 SR-1 macro security update
  • Q307410 - Excel has performed an error in module excel.exe
  • Q305495 - Fatal exception OE running Office Setup
  • Q192926 - How to Perform Clean-Boot Troubleshooting for Windows 98
  • Q325084 - Installation source for this product is not available -- SP-1 -- OffXp
  • Q228658 - Installer has insufficient privileges
  • Q306986 - Installer has insufficient privileges
  • Q234928 - Installer terminated prematurely
  • Q228668 - Internal Error 2343 During Setup -- Lotus Notes issue
  • Q304429 - Internal error 2711 when you run setup
  • Q300257 - IPF in User.exe When You Try to Register Product
  • Q229683 - List of Error Codes and Error Messages for Windows Installer
  • Q202946 - Listing of Windows Installer Errors (1000-1999)
  • Q228536 - Listing of Windows Installer Errors (1000-1999)
  • Q230879 - Listing of Windows Installer Errors (1000-1999)
  • Q229678 - Listing of Windows Installer Errors (2000-2999)
  • Q300852 - Microsoft Office setup cannot continue
  • Q260558 - Missing ODBC references in the registry
  • Q217688 - MSIEXEC Caused an Invalid Page Fault in Module MSIEXEC
  • Q297917 - MSIEXEC Caused an Invalid Page Fault in Module MSIEXEC
  • Q164921 - Mso97.dll and mso7enu.dll errors when starting program -- Off97
  • Q210437 - No qualifying product detected OFF2000
  • Q290540 - No qualifying product detected OFFXP
  • Q243579 - Office 2000 -- various errors -- can't start application required…
  • Q134733 - Office 97 -- Invalid or lost CD keys -- replacement key
  • Q156927 - Office 97 -- Invalid or lost CD keys -- replacement key
  • Q305503 - Office setup -- internal error 2263 -- need to slow down CDROM
  • Q315152 - Office XP service pack 1 will not install -- beta / pre-release version
  • Q302596 - OffXp -- encountered a problem and needs to close -- PDFMaker
  • Q304629 - OffXp: Error 25506 on odbcbcp.dll, sqlsrv32.dll, oddbse32.dll
  • Q301064 - OffXp: Error 25506 with Asycfilt.dll when running setup
  • Q310049 - Operation has been cancelled do to restrictions on this computer
  • Q308225 - Out of memory / missing menus / nimda virus
  • Q308357 - Out of memory / missing menus / nimda virus
  • Q235966 - Pid out of range -- Office
  • Q304003 - Pid out of range -- Office
  • Q240335 - Possible corrupted config.msi folder
  • Q302846 - Program> Has Not Been Installed for the Current User
  • Q321497 - Reserved error 1601 installing office (or update)
  • Q297920 - Setup cannot create a temporary file in folder …
  • Q295346 - Setup failed to locate qualifying product - please select the drive …
  • Q299774 - Setup was terminated due to an error / source file not found
  • Q325076 - Setup was terminated due to an error / source file not found
  • Q314812 - Setup was unable to update protected operating system files
  • Q194581 - SR-2 patch cannot be applied to your computer
  • Q217706 - The feature you are trying to use is on a CD-ROM or other …
  • Q217706 - The feature you are trying to use is on a CD-ROM or other …
  • Q247366 - The folder path ******* contains an invalid character -- Off2000
  • Q292582 - The folder path ******* contains an invalid character -- OffXp
  • Q305406 - The upgrade patch cannot be installed by the windows installer
  • Q274041 - The windows installer cannot update the system file -- VGX.dll
  • Q279177 - This hot fix is no longer available -- install IE 5.5 or later
  • Q236597 - This Installation Package Could Not Be Opened
  • Q290525 - This Installation Package Could Not Be Opened
  • Q294975 - This Installation Package Could Not Be Opened
  • Q295823 - This patch package could not be opened
  • Q315152 - This patch package could not be opened
  • Q213904 - Too many cell formats
  • Q168201 - Tools > Options -- Excel ipf excel.exe
  • Q290929 - Troubleshooting IPFs and Exception Errors
  • Q264652 - Unable to Install or Upgrade Windows Installer Service. -- BUG
  • Q314812 - Unable to update protected operating system files
  • Q320757 - Uninstalling Corel WordPerfect 2002 before Off install -- 1919
  • Q295346 - Upgrade Detection Fails Upgrading from Office 2000 CD2
  • Q295348 - Upgrade Detection Fails When Pointing to CD1 of SB
  • Q301239 - Upgrade Does Not Recognize Installed Office 97 SBE as Qualifying Product
  • Q255503 - What to say to client with GC6J3 CD key
  • Q314812 - Windows file protection error -- Please insert WinXp Professional
  • Q314812 - Windows file protection error -- Please insert WinXp Professional
  • Q314812 - Windows file protection error -- Please insert WinXp Professional
  • Q314812 - Windows file protection error -- Please insert WinXp Professional
  • Q265194 - Windows Installer Appears Every Time a Program Starts
  • Q238413 - Windows installer cleanup utility
  • Q323217 - Windows installer error 1605 -- when starting word
  • Q324906 - Windows installer gets broken after the install of SP-3 for Win2k
  • Q236288 - Worldwide Site Information for Registration Wizard
  • Q110402 - XL5 Err Msg: Cannot Open Printer Driver with Chart Sheet
• Files
  • Q58516 - Creating a Template
  • Q211494 - Excel Opens Without Displaying Workbook ("Cannot find the file …")
  • Q43686 - File Transfer between Excel and Works
  • Q263564 - How to Remove Protection from Worksheets and Workbooks
  • Q245409 ??? - How to troubleshoot errors saving Excel files [XL2000]
• Financial
  • Q213497 - Calculating Depreciation with the Production Method
  • Q152815 - SBFM: Accounting Terminology
• Formula
  • Q289245 - HOW TO: Use the Excel Formula Evaluator in Excel 2002
• Functions
  • Q214395 - Auto / Manual calculation
  • Q103750 - Available worksheet functions
  • Q215203 - Behavior of numbers when using automatic percent entry
  • Q214094 - Dates and times formulas for excel 2000
  • Q303216 - Dates and times formulas for excel 2001 for MAC
  • Q95948 - Dates and times formulas for excel 97 and earlier
  • Q45758 - Error values returned by functions
  • Q181201 - Hlookup, Vlookup, Lookup
  • Q214134 - How to calculate months between two dates
  • Q214315 - How to calculate the number of days between two dates
  • Q214313 - How to calculate the number of days in a month
  • Q214142 - How to use INDEX & MATCH Functions w/Multiple Criteria
  • Q151323 - How to Use the INDIRECT Function to Create References
  • Q257818 - Number not formatted as expected with percentage format
  • Q181212 - Performing a Lookup with Unsorted Data (lookups, Index/Match, Offset/Match)
  • Q214044 - Periodic annual interest rate
  • Q214241 - SumIf
  • Q260415 - SumIf, countIf, CountBlank returns #Value!
  • Q129277 - Undocumented worksheet function DateDif -- Excel
  • Q267982 - Using a Logical AND or OR in a SUM+IF Statement in Excel
  • Q214344 - Using Iterations and Maximum Change in Calculations (Circular reference)
  • Q152407 - Using OFFSET, MATCH, and MAX to Return Last Value in Range
  • Q275165 - When to use a Sum(If()) array formula
  • Q242237 - Worksheet May Not Recalculate Completely if F9 Pressed (Circular reference)
• Import
  • Q110760 - Bypassing the Text Import Wizard When You Import Files
  • Q323626 - SYLK: File Format Is Not Valid Error Message When You Open File
• Install
  • Q264596 - How to Install Office on Windows NT 4.0
  • Q238122 - Installing Office on Windows 9x with/Without Profiles
  • Q178400 - Installing Win 95 to New Folder to Tshoot Office Problems
  • Q190040 - Installing Win 98 to New Folder to Tshoot Office Problems
  • Q287453 - Best Practice Installation Methods
  • Q243039 - Clean boot trouble shooting in Windows 95
  • Q281965 - Clean boot trouble shooting in Windows 98
  • Q267288 - Clean boot trouble shooting in Windows Me
  • Q166172 - Duplicating Windows 95/98 Installation to a New Hard Disk
  • Q223300 - How to Enable Windows Installer Logging in Windows 2000
  • Q179798 - How to Increase Free Space on Your Hard Disk
  • Q263958 - How to Install or Repair Microsoft Excel Features [XL2000]
  • Q250928 - How to Reinstall Windows 98
  • Q134733 - Off97 install -- upgrade check -- enter password
  • Q134733 - Off97 install -- upgrade check -- enter password
  • Q156927 - Off97 install -- upgrade check -- full version CD key
  • Q156927 - Off97 install -- upgrade check -- full version CD key
  • Q158069 - Off97: Products That Qualify for the Office Upgrade
  • Q316769 - Office registration / activation wizard appears at each launch
  • Q290576 - Running multiple versions of microsoft office
  • Q221354 - There was a problem starting the office assistant
• Installation
  • Q290531 - What Is Included in the Product Box?
  • Q326851 - Activation vs. Registration
• KB
  • Q250581 - Windows 2000 Keywords for Searching the Microsoft Knowledge Base
• Link
  • Q327006 - Excel 2k and Xp -- updating links
  • Q141290 - How to Create a Link (to a Worksheet on Another Computer)
  • Q214127 - How to Remove Links From a Worksheet
  • Q44413 - Links in Excel
• Macros
  • Q188449 - Delete Links Wizard Available [XL97]
  • Q211372 - Delete Links Wizard Available on MSL [XL2000 - idea] (include disclaimer)
  • Q224518 - Determine if excel contains macros automating from VC++
  • Q178605 - Determine the version of a microsoft excel workbook -- C++
  • Q225078 - Errors When Trusted Resources for Add-ins is Removed (Macro Security)
  • Q145826 - How to Append an Excel Worksheet to a Database Using DAO
  • Q211561 - How to Convert an Add-In File into a Workbook in Excel 2000
  • Q211563 - How to Create an Add-in File in Excel 2000
  • Q156942 - How to Create an Add-in File in Microsoft Excel 97
  • Q213363 - How to Load a VB Listbox in Excel
  • Q291308 - How to Select Cells/Ranges Using Visual Basic Procedures (& macro resources info)
  • Q241498 - How to Send Form Mail That Uses Excel Data
  • Q161513 - Macro to Add labels to Points in an XY (Scatter)
  • Q142528 - Macro to Delete Every Other Row
  • Q213814 - Macro to Extract Data from a Chart
  • Q126093 - Macros to Delete Formula Links
  • Q141772 - XL: Visual Basic Examples Using DDE
• Miscellaneous
• ODBC
  • Q260558 - Could not load translator or setup library
  • Q260558 - Could not load translator or setup library
  • Q271908 - Download Jet components
  • Q292448 - Error 1904. Module \MCPS.dll failed to register
  • Q299611 - Error 1918 and error 1919 reinstalling office -- error 13
  • Q299611 - Error 1918 and error 1919 reinstalling office -- error 13
  • Q324520 - Error 1919 -- Error 6 --component not found in the registry
  • Q320757 - Error 1919 when you start outlook or install office
  • Q292448 - Error 1919. Error configuring ODBC data source .. Access data..
  • Q295000 - Setup routines for the Microsoft access driver…could not be loaded
  • Q295000 - Setup routines for the Microsoft access driver…could not be loaded
  • Q239114 - Updated version of Microsoft Jet 4.0
• Policy
  • Q151510 - MS Technical Support Developer Consult Line
  • Q148460 - Policy: Supporting Village Software Templates for MS Excel
• Printing
  • Q141095 - How to Set Print Area to Range with Defined Name
• Procedure
• Product Code
  • Q230848 - Numbering Scheme for Product Code GUIDs for Off2000
  • Q302663 - Numbering Scheme for Product Code GUIDs for Off2000
• Remove
  • Q219423 - How to Completely Remove Microsoft Office CD1
  • Q247684 - How to Completely Remove Microsoft Office CD2
  • Q239938 - Utility to Completely Remove Remaining Office CD1 Files
• Remove Off
  • Q158658 - How to Completely Remove Microsoft Office 97
• SP
  • Q197099 - Determining Which Service Pack Is Installed in Windows NT 4.0
  • Q152734 - Obtain the Latest Windows NT 4.0 Service Pack
• Specifications
  • Q210393 - Disk Space Requirements for MS Office 2000
  • Q264626 - Microsoft Excel 2000 Specifications
  • Q178363 - Registry Keys Used by Microsoft Excel 97 for Windows
• SR
  • Q258323 - How to Obtain & Install Fully Downloadable SR-1 Update
  • Q245025 - How to Obtain and Install Office 2000 SR-1/SR1a Update
  • Q257983 - How to Obtain SR-1 for Administrative Installations
• Support
  • Q198172 - Clip Gallery Support Boundaries
  • Q290576 - details on running multiple versions of Office on the same computer
  • Q282087 - outlines the registry entries for controlling the My Places bar
• Training
  • Q59599 - Learn Microsoft Excel Now
  • Q71584 - Running Microsoft Excel, Second Edition
• Tshoot
  • Q245226 - Troubleshooting Installation from Compact Disc
  • Q260572 - Troubleshooting Office Programs Under Windows 2000
  • Q200116 - Troubleshooting Office Programs Under Windows NT 4.0
  • Q238259 - Troubleshooting Office Setup Stop on Windows 95
  • Q259420 - A log file to troubleshoot SR-1 update problems
  • Q293191 - Activate an end-user subscription license in office xp
  • Q313936 - Activate your product by using the telephone -- confirmation ID
  • Q321341 - Activation Wizard does not show full page
  • Q262530 - All office apps open slowly -- Norton & and 2001 -- officeav.dll
  • Q262530 - All office apps open slowly -- Norton & and 2001 -- officeav.dll
  • Q267988 - Auto update shows update already installed - may be an error
  • Q288838 - Available Troubleshooters in Windows Millennium Edition
  • Q135480 - Before Calling a Mentor: Networks
  • Q135292 - Before Calling a Mentor: Printing/Video/Fonts/Multimedia
  • Q134423 - Before Calling a Mentor: Setup/File, Disk, and Memory Management
  • Q278388 - Before You Call the Consult Line for Setup Help
  • Q313936 - Boxes missing in the activation wizard
  • Q313936 - Boxes missing in the activation wizard
  • Q243495 - Calculate message remains if 65,536 formula references
  • Q155075 - Cannot End Service Processes with Task Manager
  • Q324906 - Cannot start Office after install of SP-3 for Win2k
  • Q214788 - Cannot use answer wizard or index in help for OSB
  • Q236592 - CD key requested each time apps are started -- Win2000
  • Q273889 - Changes to the Registry Checker Tool (Scanreg.exe) in Windows Me
  • Q214394 - Column Width not the Same When Printed
  • Q227091 - Command-Line Switches for the Windows Installer Tool
  • Q133152 - Common Windows 95 or Windows 98 Printing Questions and Answers
  • Q307255 - Component checker and its use
  • Q267952 - Description of PCHealth in Windows Millennium Edition (Me)
  • Q186365 - Description of ScanDisk for Windows in Windows 98
  • Q186588 - Description of the Automatic Skip Driver Agent Tool
  • Q186099 - Description of the disk cleanup tool
  • Q185956 - Description of the Microsoft Hardware Diagnostic Tool
  • Q312310 - Description of the Microsoft Partner Action Pack Supscription
  • Q185836 - Description of the System File Checker Tool (Sfc.exe)
  • Q267951 - Description of the System Restore Utility in Windows Me
  • Q188104 - Description of the Windows and MS-DOS Report Tools
  • Q183887 - Description of the Windows Registry Checker Tool (Scanreg.exe)
  • Q278449 - Description of Windows Me System Information (Msinfo32.exe) Tool
  • Q255275 - Determine the version of your office program
  • Q260292 - Determine whether office 2000 SR-1 is installed
  • Q261934 - Differences between SR-1 and SR-1a -- Office 2000
  • Q190900 - DirectX: Description of the DirectX Diagnostic Tool
  • Q282106 - Disable the file indexer
  • Q269255 - Driver Signing in Windows Millennium Edition
  • Q111249 - Embedded Chart Shrinks After Print or Preview
  • Q302596 - Err msg starting / quitting off app with adobe PDFMaker -- XP
  • Q299699 - Error applying transforms -- verify that the specified ….
  • Q308602 - Error applying transforms -- verify that the specified ….
  • Q306604 - Excel 2000 SR-1 macro security update
  • Q181918 - Excel Number Formatting Affects Perceived Precision
  • Q280504 - Excel Safe Mode (excel /s)
  • Q278327 - Fatal exception OE in VxD DRVPPQT
  • Q142116 - Files Corrupted on Save: How to Troubleshoot Source of Problem
  • Q182196 - Floating-point arithmetic may give inaccurate results
  • Q214118 - Floating-point arithmetic may give inaccurate results
  • Q78113 - Floating-point arithmetic may give inaccurate results
  • Q306190 - Force the re-entry of the product (CD) key
  • Q306190 - Force the re-entry of the product (CD) key
  • Q213514 - Format function may return an incorrect date -- XL2000
  • Q245146 - Frequently Asked Windows 2000 Question Articles
  • Q263039 - Games: How to Troubleshoot Display Issues
  • Q45557 - Handling Corrupted Excel Files by Saving in SYLK Format
  • Q214147 - Handling Corrupted Excel Files by Saving in the SYLK Format
  • Q282106 - Hard disk runs continuously after install of office
  • Q240216 - How office 2000 manages templates
  • Q290528 - How to change company name and user name after setup
  • Q304486 - How to configure location of workgroup templates
  • Q259252 - How to Copy Files and Programs from a CD-ROM to a Hard Disk
  • Q279783 - How to create a new user profile in Windows XP
  • Q232848 - How to Create a WinMSD Report
  • Q254389 - How to Detect and Resolve Display or Printing Problems
  • Q158238 - How to Determine the Version of Windows 95/98/Me in Use
  • Q296807 - How to determine whether SP-2 is installed for Off 2000
  • Q249974 - How to determine whether SR-2 is installed for Off 97
  • Q312543 - How to determine whether the SP-1 update is installed
  • Q156826 - How to Disable and Delete User Profiles
  • Q307841 - How to download and install OffXp SP-1
  • Q300552 - How to download and install MS Office Xp web components
  • Q223300 - How to Enable Windows Installer Logging in Windows 2000
  • Q305496 - How to obtain and download the latest version of windows installer
  • Q305496 - How to obtain and download the latest version of windows installer
  • Q317146 - How to perform a clean boot in Win 2k -- msconfig download
  • Q267288 - How to Perform a Clean Boot in Windows Millennium
  • Q149235 - How to prevent file corruption
  • Q289508 - How to Read Office Application Error Reporting Signature
  • Q296067 - How to remove products -- Off2000
  • Q291793 - How to remove Zone Alarm
  • Q308923 - How to replace the windows installer files
  • Q245409 - How to Troubleshoot Errors Saving Excel Files [XL97]
  • Q291336 - How to troubleshoot printing problems
  • Q291344 - How to troubleshoot printing problems
  • Q185837 - How to Troubleshoot Program Faults with Dr. Watson
  • Q275481 - How to Troubleshoot Program Faults with Dr. Watson
  • Q254986 - How to Troubleshoot Unknown Devices Listed in Device Manager
  • Q281995 - How to Troubleshoot Using the MSCONFIG Utility in Windows Me
  • Q199787 - how to turn off the find fast indexer
  • Q237957 - How to Use a Log File to Troubleshoot Setup Problems
  • Q296603 - How to Use a Log File to Troubleshoot Setup Problems
  • Q259420 - How to Use a Log File to Troubleshoot SR-1 Update
  • Q259420 - How to Use a Log File to Troubleshoot SR-1 Update
  • Q212323 - Import from excel to word looses currency format
  • Q291458 - Import from excel to word looses currency format
  • Q202945 - Invalid or lost product keys -- handling customers with
  • Q232142 - Invalid product key during installation
  • Q93503 - Isolating General Printing Problems." For Windows NT
  • Q214253 - Linking to Data in a Damaged File
  • Q179886 - List of Supported File Formats in MS Excel 2000 (see Q291051 for XP)
  • Q89311 - Manual Page Breaks Don't Display When Using Fit to Page
  • Q315353 - Manual replacement of windows installer files -- Win 2000 & Sp
  • Q310353 - Manually start the windows installer service in clean boot
  • Q321501 - Media content installation hangs at the EULA
  • Q321501 - Media content installation hangs at the EULA
  • Q179871 - Methods for Recovering Data From Damaged Workbooks [XL2000]
  • Q249065 - Microsoft Access can't display help -- would you like to repair
  • Q115376 - Microsoft Excel Does Not Save Print Settings for Views
  • Q277996 - MsiZap in windows installer removal issues
  • Q167081 - Off97 -- Programs may respond slowly (open and close)
  • Q236592 - Office 2000 apps close - reg wizard - NT4 / Win2000
  • Q237957 - Office 2000 log file to troubleshoot setup problems
  • Q192816 - Office SR-2 cannot locate an installation of Office 97 SR-1
  • Q290556 - Office stops in setup -- no errors
  • Q238012 - Office Stops in Setup: Troubleshooting in Windows 98
  • Q274318 - Office Stops in Setup: Troubleshooting in Windows Me
  • Q296603 - Office Xp verbose log
  • Q313937 - Opening the "save as" list is slow also happens in "open"
  • Q242479 - Overview of the Windows Installer Technology
  • Q189126 - Policy regarding missing or invalid passwords
  • Q141368 - Poor Performance from CD-ROM-Based Program
  • Q224694 - Preparing to install -- please wait while windows configures …
  • Q112101 - Print Reports Not Using Continuous Page Numbers
  • Q270125 - Program quits immediately after installing Project 2000 - GC6J3
  • Q224432 - Program quits immediately after starting
  • Q179871 - Recovering data from damaged workbooks -- XL2000
  • Q291057 - Recovering data from damaged workbooks -- XL2002
  • Q142117 - Recovering data from damaged workbooks -- XL97 and earlier
  • Q236592 - Registration wizard appears each time apps are launched
  • Q236592 - Registration wizard cannot run because the system infor…..
  • Q199901 - Removing templates removes modified database files
  • Q236592 - Required registry information is missing and this app …
  • Q190630 - Setup caused an IPF in Kernel32.dll (error 1904)
  • Q283686 - Setup command-line switches -- OffXp
  • Q202946 - Setup Command-Line Switches for Office 2000
  • Q255260 - Setup Command-Line Switches for Office 2000 SR-1 Update
  • Q301286 - Setup Failed to Locate Qualifying Product with Office 97 Installed
  • Q240324 - Setup prompts for CD when CD is in the drive
  • Q305511 - Smart tag indicators do not appear in your document
  • Q192816 - Some apps update, but others do not -- Off97 SR-2
  • Q255539 - Some printer names not listed in print dialog box -- XL2000
  • Q315765 - Speech recognition causes random characters in OffXp -- menus
  • Q291288 - Startup Switches for Microsoft Excel 2002
  • Q159474 - Startup Switches for Microsoft Excel 97
  • Q172446 - Steps to Take Before Calling Technical Support
  • Q142117 - Summary of Methods to Recover Data from Corrupted Files
  • Q110652 - Support for the interactive training CD
  • Q274090 - System File Checker Is Not Included in Windows Me
  • Q292499 - Thumbnail images do not appear after upgrade to office xp
  • Q274250 - Too Many Different Cell Formats [Note: Good description of cell formats]
  • Q191949 - Troubleshoot Spool32 Error Messages
  • Q260404 - Troubleshoot windows installer problems
  • Q133240 - Troubleshooting Device Conflicts with Device Manager
  • Q155681 - Troubleshooting Display Problems in Windows NT 4.0
  • Q97911 - Troubleshooting Font Problems when Printing
  • Q271850 - Troubleshooting Installation Problems on Windows 95/98/Me
  • Q272154 - Troubleshooting Installation Problems on Windows NT/2000
  • Q128345 - Troubleshooting Printing Problems in Windows 95/98/Millennium
  • Q214215 - Understanding the template path and normal.dot
  • Q321497 - Unregister / register the windows installer service
  • Q247674 - Utility to Completely Remove Remaining Office CD2 Files
  • Q240784 - Utility to Help Interpret Setup Log
  • Q234435 - Utility to repair internal error 2343
  • Q237957 - Verbose log
  • Q273711 - Were to obtain Xlviewer
  • Q161122 - Who supports Office 97 ValuPack components
  • Q269454 - Win installer service can't be accessed -- admin permissions
  • Q217521 - Win installer service can't be accessed -- terminal server
  • Q290301 - Windows Installer CleanUp Utility
  • Q240116 - Windows installer clean-up utility
  • Q315353 - Windows installer service can't be accessed
  • Q314810 - Windows installer service can't be accessed -- error 1335
  • Q315346 - Windows installer service can't be accessed -- error 1719
  • Q291458 - Word cannot re-establish a DDE connection
  • Q217488 - Workgroup templates setting lost after upgrading
  • Q272094 - Xcopy syntax and switches
  • Q289483 - Xcopy syntax and switches
  • Q319137 - Xcopy syntax and switches
  • Q321641 - Xcopy syntax and switches
  • Q113212 - XL5: Print Quality and Draft Quality Produce Different Results
  • Q156603 - XL97: Microsoft Excel Inserts a Defined Name in Formula
• Uninstall
  • Q176823 - Eraser Utility to Remove Remaining Office 97 Files (Q239938 for 2000)
  • Q152818 - How to Uninstall Small Business Financial Manager (SBFM.XLA)
• Updates
  • Q305095 - History of Office XP Updates
• Upgrade
  • Q212082 - Products That Qualify for the Microsoft Excel 2002 Upgrade
  • Q210437 - Products That Qualify for the Microsoft Office 2000 Upgrade
  • Q290540 - Products That Qualify for the Microsoft Office XP Upgrade
  • Q301286 - Setup Failed to Locate Qualifying Product with Office 97 Installed
  • Q295346 - Upgrade Detection Fails Upgrading from Office 2000 CD2
  • Q295348 - Upgrade Detection Fails When Pointing to CD1 of SB
  • Q301239 - Upgrade Does Not Recognize Installed Office 97 SBE as Qualifying Product
• Usability
  • Q293151 - About Office activation and reduced functionality
  • Q140333 - Add an object to the new object list -- File > New
  • Q288118 - Add-ins no longer included with Excel 2002
  • Q214060 - All available toolbars are not listed on the shortcut menu
  • Q215203 - Behavior of numbers when using automatic percent entry
  • Q211370 - CELL function with "filename" no longer volatile
  • Q77295 - Column delimiters missing in spreadsheet saved as CSV
  • Q269866 - Columns and Rows Are Labeled Numerically (R1C1; see also Q231045)
  • Q264372 - Controlling and understanding the format of cells
  • Q116289 - Converting multiple rows / columns to columns / rows
  • Q214258 - Create multiple views -- create and print report in excel
  • Q304421 - Creating charts in Excel / Chart Wizard
  • Q170089 - Dates made consecutive when charting in excel
  • Q224351 - Determine the version of an excel workbook -- Dsofile.exe
  • Q95951 - Displaying the Current Date and Time with Text
  • Q243495 - Excel does not completely calculate all formulas
  • Q104451 - Expand the edit menu to include "copy picture"
  • Q214070 - Filtering/Extracting a Record That Contains Text String (advanced filter)
  • Q63807 - Finding/Replacing Tildes and Wildcard Characters
  • Q311087 - Help file font sizes are too small / unreadable
  • Q87299 - Hide Formula Errors [IF(ISERROR())] (see also Q280094 - Not Public)
  • Q214115 - How excel solver works
  • Q125724 - How to add a bullet to an existing excel entry
  • Q291207 - How to add a bullet to an existing excel entry
  • Q93536 - How to Calculate Elapsed Time
  • Q280388 - How to Combine Cells of Information (Concatenate)
  • Q213360 - How to Convert a Numeric Value Into English Words [Macro]
  • Q181298 - How to Convert Text to Number
  • Q288732 - How to deploy Office XP web components
  • Q214143 - How to Force Excel to Always Reference the Same Cell (INDIRECT)
  • Q323567 - How to format for a bullet entry in excel
  • Q214081 - How to Lock Individual Cells in a Worksheet
  • Q235221 - How to Override Automatic Cell Formatting (When Opening CSV File)
  • Q214261 - How to Parse Data Using the Text To Columns Command (see also Q142149)
  • Q262277 - How to Remove Duplicate Records or Create Unique Records
  • Q263552 - How to Turn AutoComplete On or Off
  • Q142129 - How to Unhide Rows or Columns
  • Q189005 - How to Use Data Validation to Prevent Duplicate Entries
  • Q214094 - How to Use Dates and Times in Microsoft Excel
  • Q155179 - How to Use Microsoft Excel as Data Source for Word Mail Merge
  • Q214262 - How to Use the Forms Controls on a Worksheet
  • Q213977 - Insert a watermark into a worksheet
  • Q274827 - Links are updated even if no is selected in update links
  • Q118485 - Macro to Add labels to Points in an XY (Scatter)
  • Q123183 - Macro to export text file with comma and quote delimiters
  • Q104997 - Macro to save data as tab-delimited file without quotes
  • Q99348 - Macroless method to display the file name of a worksheet
  • Q257818 - Number not formatted as expected with percentage format
  • Q236592 - Office apps close immediately after launch -- CD key GC6J3…
  • Q255503 - Office apps close immediately after launch -- CD key GC6J3…
  • Q255503 - Office apps close immediately after launch since install of SR-1
  • Q162059 - Office Documents Open In Internet Explorer
  • Q316127 - Office Xp alternative user input update -- download and install
  • Q289273 - Overview of AutoRecover Functions
  • Q320664 - Overview of OffXp speller update -- April 25, 2002
  • Q214126 - Parsing Names in a Worksheet [into separate cells: LEFT(), MID(), RIGHT()]
  • Q93536 - Q93536 " Excel: How to Calculate Elapsed Time
  • Q214258 - Setting starting page number in header / footer
  • Q48198 - Setting starting page number in header / footer
  • Q300457 - Support boundaries for Word 2002
  • Q214246 - Template wizard -- How to
  • Q98016 - Using special characters -- Enter ASCII characters -- find 'em too
  • Q165269 - Windows CE support boundries
  • Q176472 - Wrap Text (or) Text is Wrapped Incorrectly When Typed in a Cell
• Usage
  • Q221190 - Using the Office 2000 Clipboard
• Version
  • Q290134 - Determining Whether You Have a Retail or Enterprise SKU
• Virus
  • Q176807 - How to Identify and Remove PLDT/CAR/SGV Macro Viruses
  • Q150990 - How to Use the Virus Search Add-in (WE1280)
  • Q185101 - Information About Known Macro Viruses in Microsoft Excel
  • Q49500 - List of Antivirus software vendors
  • Q154131 - Q&A About Excel Macro/Laroux Macro Virus
  • Q322993 - Virus hoax -- microsoft debugger registrar for java is not a virus
• Wish
  • Q114491 - How to Contact the Microsoft Wish Program