This external data source is connected to the workbook through a data connection, which is a set of information that describes how to locate, log in, and access the external data source.The main benefit of connecting to external data is that you can periodically analyze this data without repeatedly copying the data, which is an operation that can be time-consuming and error-prone.Why shouldn't it update when opening is via VB ? Thx Bernard" id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="3752933" / Thanks for your reply David, I'll certainly try it when I am back in the office -holidays now. Open ("C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis\FUNCRES. When opening an Excel workbook with links to Bloomberg, for continuous updates, the updates do not happen ...? Best regards David Grugeon M-0429 029 836 P-(07)3263 7786 But you state that it will not refresh continuously ...? This normally refers just to links to other spreadsheets. Refresh All , run this after loading the workbook and then use the Timer Function to repeat it at intervals. Open ("C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis\ATPVBAEN. Instead of using those as hard-coded input data, you can create an Excel formula that will retrieve stock prices for a given date.
If the external data source that you want to access is not on your local computer, you may need to contact the administrator of the database for a password, user permission, or other connection information.
For Professional Plus the default is what you may be used to, a Windows Installer Package.
Some financial models need to reference stock quotes at certain dates.
One other difference, besides license model, between Pro Plus and Professional Plus is the default install technology.
For Pro Plus, the default is a method called Click-to-Run.