Preventing refresh link prompt

[MTBer]

Is it possible to stop excel asking if links want to be refreshed whe
opening a file. I'm having to distribute a file to users who won't hav
access to the source files it is linked to. I do not want to break th
links.

I can make a small macro file that would open the the file and no
refresh the links but I'm looking for a tidier bit of vba to put in th
actual file, thanks

 

[Dave Peterson]

Depends on the version of excel you and your pals are using.
Edit|Links|Startup Prompt Button
is where this is set.

In earlier versions, I'd use that helper workbook. The links question gets
asked before any code could do anything.