Re: Enable automatic refresh prompt

The Edit=>Links is greyed out. This data refresh it is prompting for is for
an ODBC link out to an Oracle Database...


"Tom Ogilvy" <twogilvy@xxxxxxx> wrote in message
news:OTw1CXnIGHA.984@xxxxxxxxxxxxxxxxxxxxxxx
> If you are talking about updating links, in xl2002 and earlier, you can
> either have the links update with no prompt or be prompted. Code doesn't
> run before the question is asked and if you are opening the workbook with
> code from another workbook, I don't believe displayalerts will suppress
> this - however in that situation, you can just use the UpdateLinks
> argument
> in the workbook.Open command to suppress it.
>
> In Excel 2003 there is an option under Edit=>Links to suppress it.
>
> (I could be misremembering, but I don't believe this option was added
> until
> 2003. If it was any earlier, it was xl2002, but I believe not).
> --
> Regards,
> Tom Ogilvy
>
>
> "Richard Edwards" <do.not.use@xxxxxxxxxxxxxx> wrote in message
> news:uROueRmIGHA.604@xxxxxxxxxxxxxxxxxxxxxxx
>> I am trying to disable the automatic refresh prompt when loading a
> workbook.
>>
>> I have tried the Application.DisplayAlerts = False but no joy.
>>
>> Anyone help?
>>
>> Thank you.
>>
>> Richard
>>
>>
>
>


.

Relevant Pages

  • Re: Enable automatic refresh prompt
    ... I am not familiar with that prompt - sorry. ... This data refresh it is prompting for is ... >> Regards, ... >> Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: Importing Text Files
    ... Then select import into>new worksheet ... You can also change some the setting regarding how the data refresh ... If the file name is always the same take a check mark out of>prompt ...
    (microsoft.public.excel)
  • Re: file name in a formula
    ... Lori Miller wrote: ... only get the prompt once for each workbook. ... Dave Peterson ...
    (microsoft.public.excel.worksheet.functions)
  • Re: workbook_open
    ... This is not a workbook setting. ... "julio" wrote in message ... > "Tom Ogilvy" wrote: ... >> the prompt to update links is fired before any code runs. ...
    (microsoft.public.excel.programming)
  • RE: Finding what has changed.
    ... 'and use the 'This Workbook' event SheetChange to track any changes made.. ... i.e., my macros may make a change that needs to be saved, or the user makes a ... prompt 'Do you want to Save'. ...
    (microsoft.public.excel.programming)