Errata

Excel Hacks

Errata for Excel Hacks

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.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page 62
hack #26: replace unwanted characters

hack number 26 does not work with this nuisance that often gets into excel when
importing data, namely code 160. Word can identify and get rid of it but excel can't
recognise it. How come?

Anonymous   
Printed Page 165
Figure 5-29, cell E2

In cell E2, the figure currently shows the value 200. The correct value should be 180 for the speedometer chart to work properly

Anonymous  Oct 14, 2008 
Printed Page 176
3rd Paragraph from the bottom

Middle line of VBA code reads '...=3,VLOOKUP(B1,Table2,3,FALSE),...' and it should read '...=3,VLOOKUP(B1,Table3,2,FALSE),...' .

Anonymous  Oct 09, 2009