Pivot Table Data Crunching: MS Excel 2010 errata?

[emilG]

Is there a list of errata for Mr. Excel books and sample files anywhere?

I just downloaded the sample files for 'Pivot Table Data Crunching: MS Excel 2010' and discovered a #REF! error in one of the sample workbook data worksheets [specifically, row 17 of the Data tab in PTChapter04.xlsx]. Didn't find anything in Chapter 4 of the book to indicate whether this is intentional or not...

 

[Derek Brown]

Hello and welcome to The Board.
Yes, there are 447 instances of #REF on the worksheet in the sample file.
The Errata is usually available on the Publisher's web site but there is only a single page errata for this book and that does not refer to this particular problem.
Some of the Customer names can only be seen on two pages in that chapter (there are more than 500 Customers in the table) so it should not make much difference if you just replace the #REF entries with a name of your choosing.

 

[emilG]

Hello and welcome to The Board.
Yes, there are 447 instances of #REF on the worksheet in the sample file.
The Errata is usually available on the Publisher's web site but there is only a single page errata for this book and that does not refer to this particular problem.
Some of the Customer names can only be seen on two pages in that chapter (there are more than 500 Customers in the table) so it should not make much difference if you just replace the #REF entries with a name of your choosing.

Thanks, I thought as much but wanted to make sure...