#REF# Problem

  • Thread starter Thread starter debbiep
  • Start date Start date
D

debbiep

I set up a spreadsheet that is run on formulas, which is reading from
ACCESS query. Every time the query refreshes, if there is a change,
all my formulas turn to #REF#. Why does it not just update? What can
I do to correct the problem so that it will refresh along with the
query? Thanks in advance.
 
I set up a spreadsheet that is run on formulas, which is reading from
ACCESS query. Every time the query refreshes, if there is a change,
all my formulas turn to #REF#. Why does it not just update? What can
I do to correct the problem so that it will refresh along with the
query? Thanks in advance.
Click to expand...

I have the query in worksheet1, then I have a spreadsheet that feeds
off the query in worksheet2, which updates fine, but worksheet3 gets
information from worksheet2 and all i get is #REF# in all the cells
that have a formula linking to worksheet2.
 
Back
Top