Library Access for the SAS Add-In for Microsoft Office

If the SAS add-in attempts to write data to a table on the SAS Metadata Server, and the structure of the updated table is different, the metadata is not updated. For this reason, it is advisable to regulate Write access to registered tables from Excel, Word, and PowerPoint. Read access, for the purposes of querying SAS OLAP cubes using Excel, requires no special consideration.
Access to registered libraries is determined in part by the library access method. By default, all libraries that are registered on the SAS Metadata Server are Read-only. SAS Add-In for Microsoft Office users cannot create, add, or delete tables. The default library access method can be changed, as described in Review Library Access in SAS Enterprise Guide.
CAUTION:
To maintain referential integrity on the SAS Metadata Server, it is advisable to inform the SAS Add-In for Microsoft Office users about their permissions to access registered libraries.