11-07-2017 06:52 AM - edited 11-07-2017 07:03 AM
We are currently running SAS Enterprise Guide x32 V 184.108.40.20619 and the Office add-in x32 of the same version number. These are sequenced and deployed with App-V 5.
We are upgrading from office 2013 to office 2016 in our previous 2013 environment everything works fine (no errors).
In our 2016 Environment if a large amount of data is exported to Excel via SAS Enterprise Guide you get the following error:
I have re-sequenced SAS in our 2016 environment and still get the same issue.
Is our SAS version too old to work with office 2016?
Any ideas of a work around for this issue?
Any help will be hugely appreciated.
11-07-2017 09:12 AM
Looks to me like the quite old (current version is 7.13) EG does not recognize the newer Office 2016, and assumes the old limitations.
11-08-2017 11:14 AM
You might want to post the generated code (or code used).
The 256/ 65535 limit looks like you are attempting to write to version of Excel from 20 years ago and not a current XLSX file.
I will say any Excel file with 1800+ columns is a problematic thing to begin with.