Formula does not work after refresching data obtained from other excell file

I have a file which is connected to several other excell files; the data from these files is used in calculations. When I refresh this data using "refresh all" my formulas do not work anymore.

E.g. The formula I entered is:

" ='FA raw'!C23/'FA raw'!C22! "

after using "refresh all" the formula has changed to

" ='FA raw'!#REF!/'FA raw'!#REF! "

However, the cells which is refered to still exist and have a value.. Why does this happen and how can I prevent it? The connection to the other file has been made by going to the "data" tab, enter a new connection and use"existing connection".

greetings,

Robbert

I have a few different studies that I summarize in one workbook

I see your point. I tried to make an example file which I can share with you, but I do not have the same problem with the example files so it seems to be file specific.

The problem seems to be related to the syntax. Say I have two sheets; "Data" in which I recieve data from another workbook called "Original", and and a sheet "calculations".

I creat the formulas in "Calculations" by clicking the cells in "Data". Usually the syntax is:

='Data'!A1

But sometimes the syntax is:

=Table_Original[@Value]

I don't know why this happens because I create all the formulas by clicking the cells. Anyway, when I changa data in the original workbook and refresh the connection, the first syntax does not give any trouble, but the second syntax does, saying:

='Data'!#REF!

It seems when I change everything to the first type of syntax (just a sheet refrence) the workbook is fine.

Thanks. That helped a lot