problem with links to other excel files

[scalvitto0815]

I have an excel file that has links to 5 other excel files. when I open the file, the klinks from 4 of the files refresh and the data is there. The link to one file always breaks and in the link the sheet name always turns to REF#

 

[Skybluekid]

Have you tried using power query to resolve the issue?

 

[scalvitto0815]

no, i haven't. I'll try it .