Is it because you are linking to a pivot table? Or are you linking to plain
data/text fields?

"Fatsofoureyes" wrote:

I have a spreadhseet with links to several workbooks involving complex
functions. If the linked workbooks are all open there is no problem. If I
save the spreadsheet and re-open when the linked wworkbooks are shut all the
formulas show as #REF!
How can I stop this happening