Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon COM /
avatar image
Question by ralph.nohe · Jun 24, 2018 at 06:02 PM · eikoneikon-com-apiexcelvbarefresh

How to disable automatic TR data refresh in Excel?

When opening a workbook that contains TR data, the links are refreshing automatically. How can I disable the automatic update, and switch to a purely manual refresh, i.e. by using the refresh buttons in the TR add-in ribbon?

People who like this

0 Show 1
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
ralph.nohe · Jul 09, 2018 at 03:21 AM 0
Share

AHS - see my answer below. Consider this closed. THX.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov.1 · Jul 09, 2018 at 10:45 AM

@ralph.nohe
I'm afraid was no mention that you wanted to use VBA in your original post, hence the misunderstanding. If you want to use VBA to refresh Eikon Excel functions in your workbooks, please see this thread.
Does this give you what you're looking for?

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by Alex Putkov.1 · Jun 25, 2018 at 12:47 PM

@ralph.nohe
This forum is for software developers using Thomson Reuters APIs. Your question would be best directed at Thomson Reuters Helpdesk, as it's not related to software development.
To answer your question, you have two options: switch Excel to manual calc or click Pause updates button on Thomson Reuters tab in Excel ribbon.
If you need any further assistance with this, please contact Thomson Reuters Helpdesk by either calling the Helpdesk number in your country or by using Contact Us capability in Eikon application.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by ralph.nohe · Jul 09, 2018 at 03:20 AM

The answer provided is not exactly what really helps me because I was looking for a more sophisticated approach using VBA and the macros underlying the TR Excel plugin. Yes, indeed I am not a registered TR API developer, but I wasn’t getting an in depth assistance from the regular TR helpdesk when contacting them separately, so I hoped for a much more detailed support. Thanks anyways!

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
8 People are following this question.

Related Questions

Can I obtain News with the COM API?

Synchronous Refresh Methods for VBA in Excel

Can I find the default Eikon for Excel RHistory fields for an instrument using the COM APIs and VBA?

Download manager URLs

How does AdfinX, DEX2 RSearch etc., now stored in X, Y or Z Bin folders, affect my VBA API calls?

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges