Question Re: automatic sign-in and refresh of tables in SAC add-in... in Technology Q&A

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

MelCalucin — Fri, 02 Feb 2024 16:13:49 GMT

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

Re: automatic sign-in and refresh of tables in SAC add-in...

N1kh1l — Mon, 05 Feb 2024 12:27:00 GMT

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

Re: automatic sign-in and refresh of tables in SAC add-in...

MelCalucin — Thu, 08 Feb 2024 15:48:39 GMT

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

Re: automatic sign-in and refresh of tables in SAC add-in...

MelCalucin — Tue, 04 Mar 2025 15:24:06 GMT

There isn't a solution for this.

I created this enhancement request.

https://influence.sap.com/sap/ino/#/idea/332842

Please vote!

Thanks!

Regards,

Mel Calucin