BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
RichHebel
Fluorite | Level 6

Our office is upgrading to Office 2016.  

The first user they upgraded started having problem using a libname db xlsx statement.

I get an 

error xlsx engine can not be found.

 

v 9.4  1m3  and v 9.3     Windows 7   32 and 64 bit.  

 

If I install sas on a machine that has already been updated, it works fine.

I think it's has to do with the aceexcl.dll file but not familiar enough.

 has anyone else ran into this?

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
RichHebel
Fluorite | Level 6

It appears that our support team neglected to install the Microsoft Access Run-Time 2016 components.  This resolves the issue.

Thank you all. 

View solution in original post

10 REPLIES 10
JuanS_OCS
Amethyst | Level 16

Hi,

 

I never have seen this issue, not too many people around with Office 2016. But I can share what I know and my guesses.

 

The System Requirements of the SAS Add-in for Office: http://support.sas.com/documentation/installcenter/en/ikmsofficeintsr/68008/PDF/default/sreq.pdf

 

It says:

One of the following versions of Microsoft Office is required:

• Microsoft Office 2007 

• Microsoft Office 2010 (32-bit or 64-bit)

• Microsoft Office 2013 (32-bit or 64-bit)

Microsoft Office 2016 (32-bit or 64-bit) (requires SAS Add-In 7.12 for Microsoft Office)

 

Could you check the version of the SAS Add in on the PC that is working, and in the PC it is not working? Maybe you just need to update the Add-in on the Pc that is not working. At least it is worthy to check the versions.

 

I Hope this might work, please let us know.

JuanS_OCS
Amethyst | Level 16

Hahaha, some kudos for you Kurt. 🙂

RichHebel
Fluorite | Level 6

It appears that our support team neglected to install the Microsoft Access Run-Time 2016 components.  This resolves the issue.

Thank you all. 

RichHebel
Fluorite | Level 6

If the 2016 isn't compatible because you had a click to run install.   Use of the 2013 ones will work also.

 

sathya66
Barite | Level 11

Hi,

We are  planning to upgrade our office analytics to 9.4  so please can you help ,what are the first steps do I need to consider.

Thanks,Sathya.

Kurt_Bremser
Super User

@sathya66 wrote:

Hi,

We are  planning to upgrade our office analytics to 9.4  so please can you help ,what are the first steps do I need to consider.

Thanks,Sathya.


Please post your question in a new thread. This topic is solved.

DKBMIL
Calcite | Level 5

Similar problem here.  Recently upgraded to Office 2016, we use SAS DDE Procedures to 'call' previously created Excel templates, then proceed to update that template with SAS results, close and save.   At first, my procedure could not find the 'template', then I dicsovered it had to be defined and associated in the 'PERSONAL' template folder of Office 2016.  Did that, started to work.   But today, now not working, my SAS procedure sits and spins, unable to locate or open the template. 

RichHebel
Fluorite | Level 6

Yeah, I hadn't even experienced the DDE side of it, but our London Office called with the same problem.

When they used the generic start Excel, the new screen in excel 2016 opening a file caused it to lock.

When they specifiec a specifc spreadsheet they had better luck, but still experience some blips and bumps.

I'll know more after they've played with it more.  

Virender
Calcite | Level 5

Hey DKMBIL,

 

did you find the solution for that?

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 10 replies
  • 7520 views
  • 6 likes
  • 6 in conversation