Auto Refresh without open source file

[RachealTong]

I have one master file link up with few worksheet (sources) which save in different file name. When i open the master file, it show prompt a message "Excel cannot update one/more links. To update the link open all the link source files. To be sure all calculation are updated"

what should i set & i dont want open the link source file everytime open te master file. The excel still able to refesh the links in excel workbook. Anyone can advice & help
thanks.

[pike]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

[DonkeyOte]

@Pike - dupe is in Tips & Tutorials and thus "out of bounds" - have re-opened this thread accordingly - though I suspect this very much a case of "after the horse has bolted"

[Sibrulotte]

Sooooo,
where's the solved thread? I'm interested in this.