In reply to Alex Chaplin.

This feature was added in v7.13 (Nov 2016). And your idea for the auto-refresh works, as long as other users also have the SAS Add-In for Microsoft Office installed. If that's not the case, then you would need to automate the refresh using AMO scripting or using the other scheme you suggested.