Formula linking to external data import returning #REF

[2709236]

I'm pulling data into Excel from an external link to an Access database. This information is being pulled in in segments, and they will need to be compiled on one worksheet and subsequently imported into SAP (it's building a journal entry).

Currently I have a separate worksheet with formulas pointing to the data on the other tabs which pull data in from Access via a connection. The problem is that when I refresh the data, all my formulas return #REF errors.

Is there a way to avoid this?

[2709236]

Bumping this question back to the current stream. . .

Maybe I was too vague or this is just a dumb question. Either way, I'll try to rephrase and hopefully someone will respond.

The issue is that I'm trying to reference a cell that is linked to a table being pulled in from Access, but when it refreshes my formulas return #REFs. I think I may have my answer now, but I'm just looking for clarification.

If I build my formula as '=' and then click on the cell I want to reference, it gives me a formula like:
=Table_Query_from_MS_Access_Database etc, etc.

I'm wondering if I need to manually build the formula in the same way as if I were pointing to a pivot table. Manually reference the worksheet and cell. I will try that today unless someone can confirm that this will not solve my issue.

Thanks in advance.

[Colin Legg]

If you right click on the range where the data is imported, you should see a "Data Range Properties" option. Choose it and then, near the bottom, choose "Overwrite existing cells with new data, clear unused cells".

[2709236]

Thank you very much! I figured I was missing something.