According to my boss at work, an Excel sheet only containing this Macro should be automatically updating (from Bloomberg) whenever it opens: 

Please Login or Register  to view this content.
Can anyone confirm that this is actually the case? And if not, might there be another way of ensuring automatic update of data from Bloomberg (not involving VBA)?

Thank you!