Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 17th, 2004, 05:56 AM
Authorized User
 
Join Date: Nov 2003
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default Automatic links in Excel 2000

Hi,
I am linking two workbooks.
In the first I have all basic data and in the other I have links to the first just to get the names right.
When I open the second workbook, Excel ask whether to update the links or not. What I want is to get rid of the messagebox and always have the links to update automatic.
I know that this is possible to do in Excel 2002, but I have not get it to work in Excel 2000.

Thanks in advance
Piblon

 
Old November 19th, 2004, 03:56 PM
Registered User
 
Join Date: Nov 2004
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

In Excel goto Tools -> Options and open the Edit tab. At the bottom left theres a checkbox for "Ask to update Automatic links, uncheck it.
 
Old November 22nd, 2004, 02:10 AM
Authorized User
 
Join Date: Nov 2003
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanx,
Sometimes I am too blind too see.






Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Excel - File Links - VBA a_barnsley Excel VBA 1 July 23rd, 2007 10:48 AM
Update links in excel file Wall st Guru Excel VBA 2 December 11th, 2006 05:09 AM
Removing external links in Excel tcarnahan Excel VBA 9 February 22nd, 2004 07:21 AM
Excel in win 2000 to excel winxp (excel 2002) Max Excel VBA 3 August 28th, 2003 04:44 AM
Links to MS Excel Worksheets Dudester Classic ASP Basics 0 June 7th, 2003 02:08 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.