Errata
The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version | Location | Description | Submitted By | Date submitted | Date corrected |
---|---|---|---|---|---|
Printed | **NOTE** |
Microsoft Press | Nov 11, 2005 | ||
Printed | Page 42 |
"Personalize" should be "Popular" On page 42, the 3rd sentence in the box at the top of the page titled "Belly Up to the Mini-Bar" contains an incorrect menu option choice. Change: "Click the Microsoft Office Button, click Excel Options, and in the Personalize category, select or clear the Show Mini Toolbar On Selection check box." To: "Click the Microsoft Office Button, click Excel Options, and in the Popular category, select or clear the Show Mini Toolbar On Selection check box." |
Microsoft Press | May 06, 2010 | |
Printed | Page 50 |
Incorrect information about template files |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 57 |
XLTXM should be XLTM On page 57, the first bullet point references the wrong file extension. Change: "Excel Macro-Enabled Template (XLTXM)" To: "Excel Macro-Enabled Template (XLTM)" |
Microsoft Press | May 06, 2010 | |
Printed | Page 63 Figure 2-34 |
All references in this section refer to 'Open' dialog box which is implimented in Vista only. This is icorreect and misleading for users using Excel 2007 in Windows XP. Functions refered to in this section are not available to XP and earlier implimentations. Note from the Author or Editor: |
R H Bailin | Sep 02, 2010 | |
Printed | Page 63 Figure 2-34 |
All references in this section refer to 'Open' dialog box which is implimented in Vista only. This is icorreect and misleading for users using Excel 2007 in Windows XP. Functions refered to in this section are not available to XP and earlier implimentations. |
R H Bailin | Sep 02, 2010 | |
Printed | Page 509 1st paragraph and Figure 14-1 |
The references to OR and AND in the first paragraph are reversed. The formula on line three should read: Note from the Author or Editor: |
G Nix | Aug 13, 2011 | |
Printed, PDF, ePub, Other Digital Version | Page 714 last paragraph |
You have an incorrect cell reference where it says: "The data has been filtered to show the numbers of a single category, Mystery, but by using the filter control at the right edge of cell B2, we could switch the table to a different category (or combination of categories). Note from the Author or Editor: |
Ronald Black | Nov 08, 2012 | |
Printed | Page 966 |
"seven" should be "64" |
Microsoft Press | Jul 13, 2010 |