SAS Add-in for Microsoft Office (Excel) limits

[laika_matias]

What is the maximum data size (columns/rows) that I can load into Excel using the SAS add-in (8.3.1)? Are there any limits?

[andreas_lds]

Yes, limits exist: https://support.microsoft.com/en-gb/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-2...

[laika_matias]

I didn't think about data display limits in Excel, but for example, when I import data from SAS through the SAS Add-in in Excel into a pivot table, how large can the SAS data be for Excel to handle it?

[andreas_lds]

Depends on the hardware. I never used the addin.