Do not show update links upon opening a worksheet.

Hello Experts,
I have been searching for a way to distribute an excel Workbook that contains many links which need to be updated only when called upon. I have found answers that say place this macro in your PERSONAL.XLSB but this is not an option considering that any machine should be able to run this sheet. Is it possible to have a Workbook run a do not update links macro before excel asks to update?
fun_gAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris BottomleySoftware Quality Lead EngineerCommented:
try tools options calculations and deselect update remote references.

Chris
0
nike_golfCommented:
I think you could un-check the "Update remote references" box in the calculation tab in /tools/options.

NG,
0
nike_golfCommented:
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

fun_gAuthor Commented:
Hello to you both,
The box was unchecked and is not set to update but still asks if I would like an update when opening the file. just for clarification purposes I am trying to avoid any screen asking if i want the links updated so that no one can accidentally select to update the links. The link above tells how to update automatically.  
0
RobSampsonCommented:
You can also try:
Tools --> Options --> Edit --> Ask to update automatic links.

Or, you can get users to open the file from a VBS file, by passing a parameter that specifies UpdateLinks and ReadOnly:

http://msdn2.microsoft.com/en-us/library/aa195811(office.11).aspx
expression.Open(FileName, UpdateLinks, ReadOnly, ......

'===================
strExcelFile = Replace(WScript.ScriptFullName, WScript.ScriptName, "") & "test.xls"
UpdateLinks = False
ReadOnly = True
Set objExcel = CreateObject("Excel.Application")
Set objWB = objExcel.Workbooks.Open(strExcelFile, UpdateLinks, ReadOnly)
objExcel.Visible = True
'===================

Regards,

Rob.
0
Chris BottomleySoftware Quality Lead EngineerCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fun_gAuthor Commented:
This link contained the perfect answer. It is titled "Manual update and no message".  Thank you for your help.
0
fun_gAuthor Commented:
The best part of this solution is that the settings are transfered to other computers.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.