excel invalid reference
 

I had that error too.
The easiest is to find (ctrl+f) and write there to find this
#REF
and in the options below
look in: pick up formulas
It will tell you where are the bad reference
Hope it does help!