Reference error when applying autofilter

[babycody]

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 afterwards. I can have a cell above with the same formula return a value, but the one below return the REF error. It only appears to be doing this on this particular computer. Nobody else seems to be experiencing the same problem. Does anyone know what could cause this?