It's dynamic as long as the TOS platform and your spreadsheet is active. It's a wonderful asset as I created a custom "Decision Support Dashboard" in Excel. The Dashboard contains all the data and analysis and alarms required to make decisions all in one small panel.
When you reload your spreadsheet, you must manually choose to reactivate the link. After that you are good to go.