Administering the SAS Add-In for Microsoft Office |
If the 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.
![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.