Excel: The Missing Manual
by Matthew MacDonald

The following errata were *corrected* in the 4/07 reprint:

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  Please specify the printing date of your copy.

This page was updated November 30, 2006.

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem
	?page-number?: reader question or request for clarification


Corrected errors:


(31)  1st paragraph;
Last sentence of paragraph changed to section title "Opening Multiple Spreadsheets at Once".


(53)  3rd para;
1st letter of 2nd sentence capitalized.


(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


{79}  4th paragraph 3rd line;
"backward slash" changed to "forward slash"


(146)  First Tip;
It said Format - Column - Unhide twice.  Second now reads Format - Row 
- Unhide.


(149)  middle of the page;
"too" changed to "to"  
("The only way you can tell...is to look ...)


(196)  1st Line;
"Referring to Other Workbooks"
"$92,200.12" changed to "$94,200.12" 


(220) Note at the bottom of the page;
Note: Both GCD() and LCD()....
changed to:
Note: Both GCD() and LCM()....


(248)  Third para below the bullets,line two.;
"$26,133.33" changed to "$2,613.33."


{257}  1st paragraph 4th line;
...the altered text becomes "Hello There."
changed to
...the altered text becomes "Hello There".


{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])


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


(344)  Last bullet item;
changed to "To move to the last record ..."


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


{422}  In the box "How Excel Anchors Charts", 2nd paragraph, 1st sentence;
"Figure 16-4" changed to "Figure 16-6"


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


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