SAS add-in in MS Office, doesn't work with win10

blueskyxyz — Wed, 14 Sep 2022 11:59:13 GMT

hi guys,

I want to use the sas add-in in ms office, but it doesn't work on my pc with win10.

seek for your help, thanks.

Re: how to solve this issue

anuraagjv — Wed, 31 Aug 2022 15:50:56 GMT

When we see the error about, 'Could not load file or assembly GTLManagedWindows.dll', it almost always means there is a bitness mismatch between Office and the SAS Add-in.

In other words, the bitness of Office and the bitness of the SAS Add-in have to be the same.

Next steps to take:

1. First, determine the Office bitness.

So open Excel, then select File, Account, click the ?About Excel icon showing the Excel version and bitness.

Make note whether it is 32bit or 64bit.

Then close Excel.

2. Second, uninstall the SAS Add-in.

Then reinstall the SAS Add-in.

3. During reinstall, the install should detect the Office bitness and install the correct SAS Add-in bitness.

However, if a panel labeled 'Select SAS Add-in for Microsoft Office Mode' occurs during reinstall, select the choice for '64-bit Native Mode' if Office is 64bit or select 32bit mode if Office is 32bit.

That should take care of it.

Finally, open Excel and you should have a SAS menu selection.

Re: how to solve this issue

blueskyxyz — Wed, 14 Sep 2022 01:35:30 GMT

Thanks anuraagjv for your reply.😀

topic Re: how to solve this issue in Administration and Deployment

SAS add-in in MS Office, doesn't work with win10

Re: how to solve this issue

Re: how to solve this issue