Forum Discussion
Fromulas are replaced by #REF
I need help and I can't find anything that answers this specific problem. At my job our excel worksheets use formulas that reference other excel worksheets found on another server. Everything works f...
I would advise to pull in that data using Data, Get Data, From File, From Workbook and set the table to refresh when the file opens (and perhaps every 60 seconds after that). Then have your formulas point to the newly added sheet. If the connection now fails, you will get a refresh error, but your formulas will remain intact.