automatic sign-in and refresh of tables in SAC add-in for Microsoft Excel when opening Excel file

[mcalucin]

I'm using  SAC add-in for Microsoft Excel.

Is there a way to have SAC add-in for Microsoft Excel automatically sign-in and refresh the tables when opening the Excel file?

Thanks,

Regards,

Mel Calucin

[N1kh1l]

mcalucin

For automatic sign on you have to get some form of single sign on implemented for your tenant. But once you are signed in if you set your workbook preference to refresh automatically while creating the report as shown below, they will always refresh automatically when opened.

 

Hope this helps !!

Br.

Nikhil

[mcalucin]

Hi Nikhil,

Thanks for the suggested fix.

I have SSO on the SAC tenant.   Hence, I do not have to login to SAC.   However, I still have to sign in when opening the Excel file that is connected to the SAC tenant.  Only then will the table be refreshed.

Regards,

Mel Calucin