Suppress Update Links

  • Thread starter Thread starter Tim Childs
  • Start date Start date
T

Tim Childs

Hi

Is there a way to <turn off> the option to update links on a file
which is being opened manually (as opposed to in VB). (There are a lot
of VLOOKUPS in the file referencing an outside file).

Thanks

Tim
 
Hi

thanks for this - I had not spotted it previously.
all this seemed to achieve is suppressing the choice - it still updated the
links when the file opened.

any other possible avenues, please?

thanks

Tim

PS I looked at Application Events around opening the file but these
"trigger" after the Update dialog box..
 
Came across these replies by: Bob Flanagan, John Wilson via a Google search
: http://tinyurl.com/2nms5

--
hth
Max
-----------------------------------------
Please reply in thread
Use xdemechanik <at>yahoo<dot>com for email
---------------------------------------------
Tim Childs said:
Hi

thanks for this - I had not spotted it previously.
all this seemed to achieve is suppressing the choice - it still updated the
links when the file opened.

any other possible avenues, please?

thanks

Tim

PS I looked at Application Events around opening the file but these
"trigger" after the Update dialog box..
Click to expand...
 
And if you're using xl2002 (or higher??), you can:

Edit|links|click the Start up Prompt button
and specify what you want there.
 
Hi

thanks but these tips depend on opening the file from another file via
VB which is not error-proof: people forget to do this

I wondered if this would work:

Write a UDF that includes a line of code to open the dependent file
(after testing if it is open or not) and make it a volatile UDF e.g.
by including the RND function to ensure the Excel calculation
algorithm includes it.

Then when main file is opened the dependent file will open and links
will not be slow.

MY QUESTION THEN BECOMES:

in what order does Excel decide to do the calculation: I obviously
want the UDF to fire as early as possible

Look forward to response

Tim
 
Hi

thanks for the tip on XL2002 which I'll check out at home

we use XL2000 at work so still a problem

'************

thanks for the links to Charles W. site which were helpful but did not
answer the initial question

have tried out opening a file in the middle of a UDF but it did not
function as intended: the code stepped onto the workbooks.open command
but it did not do anything: is it specifically ruled out to open a
file in this manner

THANKS

Tim
 
UDF's called from worksheet cells are very limited in what they can do.

You can expect them to return values, but (hardly) ever change excel's
environment--including opening other workbooks.

(Imagine if it tried to open the workbook each time excel recalculated.)
 
Back
Top