Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

Office 2010 - Excel

i have Office 2010 pro installed. we have excel files that uses external links to update data, however, we are trying to disable the automatic updates of these links. we did disable it in the options menu, but still it updates when we open the filed. we also choose not to automatic update.
0
albie-de
Asked:
albie-de
  • 6
  • 5
2 Solutions
 
RunriggerCommented:
Is the target file open at the same time?
0
 
albie-deAuthor Commented:
we open the file. is does the update, witch we disabled. then we do the changes while the updated file is open.
0
 
RunriggerCommented:
Sorry, I should have asked a better question!

When you open your file with the external links - is the external file open also?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
albie-deAuthor Commented:
all the required files can be accessed. usually it's only access db's. the problem is to halt all updates until such time that the updates is required. we do not want it to automatically update.
0
 
RunriggerCommented:
there appear to be two options for external links, see image.

If the first option is selected for your workbook, links will automatically be recalculated;
ee-automaticlinks.JPG
0
 
albie-deAuthor Commented:
is there a place to disable queries. this still updates
0
 
RunriggerCommented:
simply click on to a cell which is part of the external query, and the "Table Tools" menu ribbon will automatically display on your tool bar.

Select properties, and the from the initial pop up box, your will see a connection properties button, click that and then "uncheck" the Refresh data when opening the file option.

See image
ee-mdblinks.JPG
0
 
albie-deAuthor Commented:
this should work, but what if your doc has multiple queries on different sheets in any of the cells?
0
 
RunriggerCommented:
It should not make any difference, do you still have problems?
0
 
albie-deAuthor Commented:
what we did was to disable the trusted documents. this now asks you every time if you want to run the queries. at the end, it helped but was not the one we were looking for. the answer of Runrigger was i think the one that will work, but for 50 queries, to do 1 by 1 will be a painstaking excersize
0
 
RunriggerCommented:
Albie, I am very curious about how to do this for all queries collectively. I will therefore refer to the moderators for additional help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now