Hi all,

My spreadsheet has links to other workbooks so the user is asked
whether or not to update automatic links when the spreadsheet is
opened.

Is it possible to suppress this message and update the links every
time?

I tried the following in the "ThisWorkbook" sheet:

Application.DisplayAlerts = False

But the message still comes up.

Thanks in advance for any suggestions


--
skuzapo
------------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
View this thread: http://www.excelforum.com/showthread...hreadid=471190

Hi skuzapo

See

ToolsOptions..Edit

Uncheck "Ask to update.......


--
Regards Ron de Bruin
http://www.rondebruin.nl


"skuzapo" wrote in message
...

Hi all,

My spreadsheet has links to other workbooks so the user is asked
whether or not to update automatic links when the spreadsheet is
opened.

Is it possible to suppress this message and update the links every
time?

I tried the following in the "ThisWorkbook" sheet:

Application.DisplayAlerts = False

But the message still comes up.

Thanks in advance for any suggestions


--
skuzapo
------------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...o&userid=27430
View this thread: http://www.excelforum.com/showthread...hreadid=471190

Thanks Ron,

But what happens when the spreadsheet is opened on another user's pc
Won't the change you suggested under the tools menu be pc specifi
rather than specific to this spreadsheet?

Thanks agai

--
skuzap
-----------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...fo&userid=2743
View this thread: http://www.excelforum.com/showthread.php?threadid=47119

You are correct. This is an application level setting.

What version of excel will be used to open the file?

--
Regards,
Tom Ogilvy

"skuzapo" wrote in
message ...

Thanks Ron,

But what happens when the spreadsheet is opened on another user's pc?
Won't the change you suggested under the tools menu be pc specific
rather than specific to this spreadsheet?

Thanks again


--
skuzapo
------------------------------------------------------------------------
skuzapo's Profile:
http://www.excelforum.com/member.php...o&userid=27430
View this thread: http://www.excelforum.com/showthread...hreadid=471190

Hi Tom,

We have a selection of excel versions running through out our compan
(so much for standardisation) but predominantly excel 97 SR-2.

Thank yo

--
skuzap
-----------------------------------------------------------------------
skuzapo's Profile: http://www.excelforum.com/member.php...fo&userid=2743
View this thread: http://www.excelforum.com/showthread.php?threadid=47119