fun_g
asked on
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?
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?
I think you could un-check the "Update remote references" box in the calculation tab in /tools/options.
NG,
NG,
Also check out this link it might give you some insight.
https://www.experts-exchange.com/questions/21608785/Update-Don't-Update-Links.html
https://www.experts-exchange.com/questions/21608785/Update-Don't-Update-Links.html
ASKER
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.
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.
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.ScriptFull Name, WScript.ScriptName, "") & "test.xls"
UpdateLinks = False
ReadOnly = True
Set objExcel = CreateObject("Excel.Applic ation")
Set objWB = objExcel.Workbooks.Open(st rExcelFile , UpdateLinks, ReadOnly)
objExcel.Visible = True
'===================
Regards,
Rob.
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.ScriptFull
UpdateLinks = False
ReadOnly = True
Set objExcel = CreateObject("Excel.Applic
Set objWB = objExcel.Workbooks.Open(st
objExcel.Visible = True
'===================
Regards,
Rob.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This link contained the perfect answer. It is titled "Manual update and no message". Thank you for your help.
ASKER
The best part of this solution is that the settings are transfered to other computers.
Chris