Click the cell that displays the error, click the button that appears , and
then click Trace Error if it appears.
You can find possible solutions there after.
This basically happens when you paste cells over cells referred to by other
formulas, or using a link to a program that is not running, linking to a
dynamic data exchange or running a macro that enter a function that returns #
REF!
in case you do require those cells to be referred by other formulas you
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
