Errata for Microsoft® Excel® 2010 Inside Out

Says "To save an Excel 2010 or 2007 file to share with someone using the Mac version of Excel... Save As ... 97-2003 ..." Needs updated. Excel 2008 can open these files. Excel 2011 can open these files. After Excel 2004, this advice has no longer been relevant.

Note from the Author or Editor:
If possible, reword thusly: "To save an Excel 2010 or 2007 file to share with someone using a version of Macintosh Excel older than the 2008 release, ... "

Text states: "You can move or copy nonadjacent worksheets at the same time by pressing Ctrl while you click to select the sheet tabs. Before dragging, release the Ctrl key to move the selected worksheets, or keep holding it down to create copies." The aforementioned technique as stated will not work. Regardless of the inention to move or copy, both the mouse and Ctrl key should first be released after selecting the worksheet tabs. Then, re-click and drag one of the highlighted tabs to move the group, or click and hold down the Ctrl key while dragging to copy the group. The description of how to move or copy worksheets using the mouse, is more accurately described in the Inside Out section on page 259.

Note from the Author or Editor:
It actually does work sometimes if you keep holding Ctrl, but only sometimes. So, let's make it more accurate and change the quoted errata reference to the following: "You select nonadjacent worksheets at the same time by pressing Ctrl while you click to select the sheet tabs. Then you can click any selected tab and drag to move the group, or click, press Ctrl and drag to create copies."

Text states: "The SUMIFS function does similar work to that of the SUMIF function, except you can specify up to 127 different ranges to sum, each with their own criteria". Actually, the function allows only ONE (1) range to sum. You may specify up to 127 conditional ranges, each with its own criteria, but only one range is summed.

Note from the Author or Editor:
Chapter 14, page 2, "The SUMIF, SUMIFS, and COUNTIF functions," second paragraph: Existing Text: "The SUMIFS function does similar work to that of the SUMIF function, except you can specify up to 127 different ranges to sum, each with their own criteria." Change to Read: "The SUMIFS function does similar work to that of the SUMIF function, except you can specify up to 127 different conditional ranges, each with their own criteria."

Not really a mistake--let's say "Oversight"--but it definitely is SERIOUS. All I wanted to do was subtract the data is Column B from the data in Column A. So simple--and I had your book to guide me. But still, I churned and churned for hours--getting nowhere. My problem was that--under "Pivot Table Tools/Options"--when I clicked on "Fields, Items, & Sets", the "Calculate Field" menu selection was greyed out. I tried everything imaginable to tweak the app into cooperating. But no luck! I have since found the problem and feel that this portion of the book--on "Using Calculated Fields and Items" needs to have a VERY bold note explaining that: "You cannot create a calculated field or a calculated item in a PivotTable based on OLAP source data." None of what you describe on pgs. 804-806 will work if the data source is an OLAP cube. Here is the reference to the relate KB article: http://support.microsoft.com/kb/234700

Note from the Author or Editor:
True. Thanks for the tip! O Reilly: His suggested note would work great ... if it's possible to add it without page break repercussions. Thanks, =Mark