Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#REF# Problem
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#REF# Problem
On Sep 29, 9:34 pm, "
wrote: 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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |