Bloomberg spreadsheet not updating


09-Oct-2020 02:37

There are two ways to program a spreadsheet to update automatically: every time the workbook is opened and at regular intervals that you determine.

bloomberg spreadsheet not updating-9

dating craftsman planes

Some fields are real - time so they update automatically and for some fields (which are not real time) i need to hit refrest on the Bloomberg Ribbon. So maybe a VBA code which will hit refresh every 30 seconds. 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.