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.
| 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 ..."
changed to: "... you'll lose format settings that control ...";
same in next paragraph
|
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
- Unhide.
|
Anonymous |
|
Apr 01, 2007 |
| Printed |
Page 149
middle of the page |
"too" changed to "to"
("The only way you can tell...is to look ...)
|
Anonymous |
|
Apr 01, 2007 |
| Printed |
Page 196
1st Line |
"Referring to Other Workbooks"
"$92,200.12" changed to "$94,200.12"
|
Anonymous |
|
Apr 01, 2007 |
| Printed |
Page 220
Note at the bottom of the page |
Note: Both GCD() and LCD()....
changed to:
Note: Both GCD() and LCM()....
|
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."
changed to
...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.
VLOOKUP(search_for, table_range, row_number, [range_lookup])
HLOOKUP(search_for, table_range, column_number, [range_lookup])
changed to:
VLOOKUP(search_for, table_range, column_number, [range_lookup])
HLOOKUP(search_for, table_range, row_number, [range_lookup])
|
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.
now reads:
"1 returns an absolute .... ",
"2 fixes the row ..."
"3 fixes the column ..."
"4 returns a relative ..."
|
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)."
changed to:
"...a Saturday (a value of 7) or a Sunday (a value of 1)."
|
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.
changed to:
You then move two columns to the right to cell C1, type in the number 42, and save the macro.
|
Anonymous |
|
Apr 01, 2007 |
