[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Do not show update links upon opening a worksheet.

Posted on 2008-01-30
8
Medium Priority
?
304 Views
Last Modified: 2012-06-27
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?
0
Comment
Question by:fun_g
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 20780209
try tools options calculations and deselect update remote references.

Chris
0
 
LVL 13

Expert Comment

by:nike_golf
ID: 20780251
I think you could un-check the "Update remote references" box in the calculation tab in /tools/options.

NG,
0
 
LVL 13

Expert Comment

by:nike_golf
ID: 20780267
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 

Author Comment

by:fun_g
ID: 20780721
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
 
LVL 65

Expert Comment

by:RobSampson
ID: 20780783
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
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 2000 total points
ID: 20780919
0
 

Author Closing Comment

by:fun_g
ID: 31426468
This link contained the perfect answer. It is titled "Manual update and no message".  Thank you for your help.
0
 

Author Comment

by:fun_g
ID: 20781653
The best part of this solution is that the settings are transfered to other computers.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question