How do I resolve number on screen printing as #REF

S

sallylg

I have an excel worksheet which shows the numbers perfectly, however, one
number when it is printed or print previewed appears as #REF

The number is obtained from another worksheet by formula but there is no
problem with the other worksheet.

why is this and how can I resolve it?
 
Top