Bloomberg spreadsheet not updating
You may have imported data from other applications to Excel with its build-in function - Get External Data, and updated the imported data easily by the Refresh All button. On Time Now Time Value(""), "Data Refresh2" End Sub Sub Data Refresh2 () If Application. Get Enabled Mso("Refresh Status") Then Application. On Time Now Time Value(""), " Data Refresh2" Else Active Sheet. Make sure your cursor is in the first Sub Data Refresh code section, and then press the F5 key to run the code.
However, after protecting the worksheet, the Refresh All button is disabled and the imported data cannot be updated any more. In the protected worksheet, press the Alt F11 keys simultaneously to open the Microsoft Visual Basic for Applications window. In the Microsoft Visual Basic for Applications window, click Insert Sub Data Refresh() 'Update by Extendoffice 5/28/2019 Active Sheet. Protect "123" End If End Sub Note: In the VBA code, “123” is the password we specified to protect the worksheet. In the popping up Import File dialog box, please select the external file which you have imported data from, and then click the Import button.
Also, a problem described here https://support.microsoft.com/en-us/kb/213489 just replace o Addin = obj Excel. Add("C:\blp\API\Office Tools\bloombergui.xla") with Obj Excel. I need something similar: I need to write a code, either VBA macro then a script which auto run the macro on a schedule, or just a script.
Note: This code can refresh the external data in protected worksheet which imported from Access, Text as well as Excel file.The only way so far I've found to get these cells to pull in current data is to delete them and rewrite the formulas.Does anyone have a suggestion for a Macro that would force a refresh of this data? Quit why not build an autoopen macro in the spreadsheet that refreshes the data when the workbook is opened Then your script just has to open spreadsheet (the autoopen could save it's self and send it's self as an email as well then close it's self) I take it the script is so this update can occur automatically Always Test on a copy ALWAYS No warranty or guarantee is explicitly or implicitly implied You accept and use any code or solution at your own risk If you are given a solution beyond your current skill level use with an appropriate level of caution and if using at your place of work it is your responsibilty to inform others of any support or understanding shortfall due to the source of the solution.I am copying formulas into a worksheet to get Bloomberg data, but the data is not refreshing.
You have to click on each cell to see the data from Bloomberg.