Reference error when applying autofilter

babycody

Well-known Member
Joined
Jul 8, 2003
Messages
1,395
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?
 

Forum statistics

Threads
1,085,301
Messages
5,382,801
Members
401,807
Latest member
xlWatcher

Some videos you may like

This Week's Hot Topics

Top