Preventing refresh link prompt

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

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


---
Message posted from http://www.ExcelForum.com/

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.


"MTBer " wrote:

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

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

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson