I am sending a workbook to someone I work with. They are choosing Don't Update when opening the file. The values are fine until they apply an autofilter which lets them view products by department. Then the cells recalculate, and some but not all of the cells in a column contain reference errors...