Errata

Excel 2003: The Missing Manual

Errata for Excel 2003: The Missing Manual

Submit your own errata for this product.

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 ..."
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