Uploaded March 2015 | Updated September 2026, 52 minutes ago

---

Get the Excel file here: http://1drv.ms/1bYwrTa
Unfortunately, spreadsheet errors happen every day.
This video demonstrates 5 common spreadsheet errors.
0:14 GOTCHA #1 Unintentional circular references
1:47 GOTCHA #2 Workbook set to manual calculation
2:33 GOTCHA #3 Vlookup optional parameter not used
4:28 GOTCHA #4 Pivot not refreshed
5:27 GOTCHA #5 Formulas were copied & pasted
...the list could go on but these are some of the most common errors that people make.

Cheers,
Kevin Lehrbass
twitter.com/KevinLehrbass
myspreadsheetlab.com
Get my Excel file's here: http://1drv.ms/1bYwrTa

Tumblr myspreadsheetlab.tumblr.com/post/112497441410/spreadsheet-errors-happen-all-over-the-world-every