How can we improve PI DataLink?

Auto-Update enabled by default on Excel startup

Add a setting to turn on the "Auto-Update" button on Excel startup automatically.

Note: This was previously Enhancement 26678OSI8.

20 votes
Sign in Sign in with OSIsoft
Signed in as (Sign out)

We’ll send you updates on this idea

AdminTodd Brown (Product Manager, OSIsoft) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in Sign in with OSIsoft
Signed in as (Sign out)
Submitting...
  • imaroco commented  ·   ·  Flag as inappropriate

    Eu usei o código abaixo para que assim que abir o Excel ou clicar em um botão que chamei de Botão2_Clique o VBA fica recalculando a planilha e assim atualizando as minhas variáveis.

    O Caso abaixo esta com Workbook_Open ao abrir a planilha mas também podemos usar o workbook activate quando essa planilha especifica estiver ativa que seria melhor.

    Private Sub Workbook_Open()
    Call Módulo3.Botão2_Clique
    End Sub

    Sub Botão2_Clique()
    Application.CalculateFull
    Application.OnTime Now + TimeValue(“00:00:05”), “Botão2_Clique”
    End Sub

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED