Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
microsoft.public.excel.links
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
2003 Can I stop the 'update links' option when file is opened?
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   2 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
ajnmxx  
View profile  
 More options Oct 29, 8:44 pm
Newsgroups: microsoft.public.excel.links
From: ajnmxx <ajn...@googlemail.com>
Date: Thu, 29 Oct 2009 02:44:12 -0700 (PDT)
Local: Thurs, Oct 29 2009 8:44 pm
Subject: 2003 Can I stop the 'update links' option when file is opened?
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
It seems I should be able to do this via the 'links' then 'startup
prompt' options. But whichever one of the three options here that I
choose seems to make no difference. When the file is saved and
reopened I'm still asked to update links again. The settings are
saved, so it still says "don't display the alert", but it does. Is
this a bug?

    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Robert Flanagan  
View profile  
 More options Nov 1, 1:47 am
Newsgroups: microsoft.public.excel.links
From: "Robert Flanagan" <nos...@nospam.net>
Date: Sat, 31 Oct 2009 10:47:08 -0400
Local: Sun, Nov 1 2009 1:47 am
Subject: Re: 2003 Can I stop the 'update links' option when file is opened?
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
This is a feature.  You can set the workbook to always update links but that
sounds like what you do not want to do.  The other option is to write a
macro that opens the workbook and sets the option to update links to false

Sub Open_No_Update()
    Workbooks.Open Filename:= _
        "file and path here", UpdateLinks:=False
End Sub

Put the above in your personal xls file and assign it to a button for fast
access.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"ajnmxx" <ajn...@googlemail.com> wrote in message

news:91f01d79-e3d2-431f-bc83-e6ac212b2289@v36g2000yqv.googlegroups.com...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google