Category
Description
Data tables
Troubleshooting: The results in my two-input data table are wrong
Displayed values
Troubleshooting: My formulas don’t add numbers correctly
Troubleshooting: Rounded values in my worksheet don’t add up
Formats
Troubleshooting: Decimal points in my Currency formats don’t line up
Troubleshooting: Concatenated dates become serial numbers
Troubleshooting: I can’t enter a number of hours greater than 9,999
Troubleshooting: Excel displays my time as #####
Functions
Troubleshooting: I get a #NAME? error
Troubleshooting: My IS function returns unexpected results
Troubleshooting: The PMT function produces unrealistic results
Troubleshooting: Random numbers keep changing
Hyperlinking
Troubleshooting: Excel doesn’t turn my URLs into hyperlinks
Troubleshooting: I don’t want that hyperlink
Names
Troubleshooting: My old worksheet-level names have changed
Page layout
Troubleshooting: My manual page breaks don’t work very well
Queries
Troubleshooting: The Query Wizard won’t let me get rid of a filter
Shared workbooks
Troubleshooting: Excel won’t let me share the workbook
Solver
Troubleshooting: The Solver can’t solve my problem
Sum
Troubleshooting: Inserted cells are not included in formulas
Tables
Troubleshooting: I can’t extract to a separate worksheet
Tabs
Troubleshooting: Did your Design tab disappear?
Window
Troubleshooting: Nothing happens when I try to open a workbook
XML
Troubleshooting: Excel reports a problem with the specified XML or schema source