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.