albie-de
asked on
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.
Runrigger
Is the target file open at the same time?
ASKER
we open the file. is does the update, witch we disabled. then we do the changes while the updated file is open.
Sorry, I should have asked a better question!
When you open your file with the external links - is the external file open also?
When you open your file with the external links - is the external file open also?
ASKER
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
is there a place to disable queries. this still updates
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 should work, but what if your doc has multiple queries on different sheets in any of the cells?
It should not make any difference, do you still have problems?
ASKER
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
Albie, I am very curious about how to do this for all queries collectively. I will therefore refer to the moderators for additional help.