For this issue, Excel's Help actually has to-the-point and relevant information:
-------8<-------
* Don't prompt for all workbooks I open, and update the links
automatically
This option is for the current user only, and affects every
workbook opened. Other users of the workbook are not affected.
1) On the Tools menu, click Options, and then click the Edit
tab.
2) Clear the Ask to update automatic links check box. If the box
is cleared, the links are automatically updated, and no alert
is displayed.
* Prompt in the same way for every user of the workbook
Warning: This option affects all users of the workbook. If you
choose to not update links, and not to prompt, users of the
workbook will not know the data is out of date.
1) On Edit menu, click Links.
2) Click Startup Prompt.
3) Select the option you want.
Note: You will still be notified if there are any broken links.
-------8<-------
--Suresh
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Timothy Johnson
Sent: Wednesday, April 19, 2006 4:52 PM
To: Allegakoen, Justin Devanandan; [email protected]
Subject: RE: Opening an Excel workbook with links to other data sources
Check Tools-->Options-->Calculation Tab and try changing the Calculation radio
button to Manual. That might get rid of the message.
You just have to keep in mind that you need to manually recalculate your values
if you want to see the current data.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allegakoen, Justin Devanandan
Sent: Wednesday, April 19, 2006 3:59 PM
To: [email protected]
Subject: RE: Opening an Excel workbook with links to other data sources
-------8<-------
Just-in's other suggestion was "If not you may have to fudge
something with Win32::GuiTest", but didn't elaborate on
the "something" ...
-------8<-------
Going down the GuiTest path is forcing things in a less than elegant way.
Why not have a dig around in the Object browser (available when you hit
Alt-F11 after you launch Excel) - you may have to hit Tools -> References and
check the Excel box to get the Excel references. You
may find a property or method that allows you to override the pop up in
question.
It's going to take some searching but it may be well worth the effort.
Just in
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
