#REF#

  • Thread starter Thread starter Ozzie
  • Start date Start date
O

Ozzie

For a file with linked files, every so often I get
a "#REF#" in some of the cells. After I update the links,
the problem goes away - to come back the next time the
file is opened. There's not a problem with the formula,
nor with the file that it is linked.

Any ideas?
 
It sounds like the workbook was developed in an earlier version of excel than
the one you're currently using.

The newer versions of excel want to recalculate when you open a workbook and it
notices that the workbook was created in an older version.

Maybe you could just refresh the links. (I think some have posted that they
could only get rid of this problem by creating a new workbook, copying the
worksheets into it and saving in the current version. I've never done this, but
I've never seen the problem.)
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Workbook linkage returns #REF! 4
Excel Sumproduct Ref error when table is closed 0
GETPIVOTDATA #REF! error XL2003/2010 1
#Ref! error using INDIRECT for file name 2
#REF 1
Creating copy of sheet into new file results in #REF errors 1
Using a #Ref! in a column Sum 3
#Ref! after row deletion 3

Back
Top