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 | Page 31 1st paragraph |
Last sentence of paragraph changed to section title "Opening Multiple Spreadsheets at Once". |
Anonymous | Apr 01, 2007 | |
Printed | Page 44 in the UP TO SPEED box, 2nd paragraph |
Page 44 in the UP TO SPEED box, 2nd paragraph it mentions English (United States) or Swedish (Finland). It should be "Swedish (Sweden)". |
Anonymous | ||
Printed | Page 53 3rd para |
1st letter of 2nd sentence capitalized. |
Anonymous | Apr 01, 2007 | |
Printed | Page 68 5th paragraph, 3rd line |
"... you'll loose format settings that control ..." |
Anonymous | Apr 01, 2007 | |
Printed | Page 79 4th paragraph 3rd line |
"backward slash" changed to "forward slash" |
Anonymous | Apr 01, 2007 | |
Printed | Page 146 First Tip |
It said Format - Column - Unhide twice. Second now reads Format - Row |
Anonymous | Apr 01, 2007 | |
Printed | Page 149 middle of the page |
"too" changed to "to" |
Anonymous | Apr 01, 2007 | |
Printed | Page 196 1st Line |
"Referring to Other Workbooks" |
Anonymous | Apr 01, 2007 | |
Printed | Page 220 Note at the bottom of the page |
Note: Both GCD() and LCD().... |
Anonymous | Apr 01, 2007 | |
Printed | Page 248 Third para below the bullets,line two. |
"$26,133.33" changed to "$2,613.33." |
Anonymous | Apr 01, 2007 | |
Printed | Page 257 1st paragraph 4th line |
...the altered text becomes "Hello There." |
Anonymous | Apr 01, 2007 | |
Printed | Page 281 In the first paragraph at the top of page |
The offsets in the syntax are transposed. |
Anonymous | Apr 01, 2007 | |
Printed | Page 296 Bullet point list at top of page |
The bullet point list is missing the actual allowed parameter values for abs_number. |
Anonymous | Apr 01, 2007 | |
Printed | Page 344 Last bullet item |
changed to "To move to the last record ..." |
Anonymous | Apr 01, 2007 | |
Printed | Page 405 1st Paragraph, 3rd sentence |
"...a Saturday (a value of 1) or a Sunday (a value of 7)." |
Anonymous | Apr 01, 2007 | |
Printed | Page 422 In the box "How Excel Anchors Charts", 2nd paragraph, 1st sentence |
"Figure 16-4" changed to "Figure 16-6" |
Anonymous | Apr 01, 2007 | |
Printed | Page 431 body text at top of page, and in caption for figure 16-9 |
In the two places we refer to "category access scaling," now says "category axis scaling." |
Anonymous | Apr 01, 2007 | |
Printed | Page 656 First paragraph |
You then move two columns to the left to cell C1, type in the number 42, and save the macro. |
Anonymous | Apr 01, 2007 |