When you run a stored process in Microsoft Excel in the SAS Add-In for Microsoft Office and then insert a column or row into the results, this pop-up warning appears:

It appears that one or more ranges with SAS Add-In for Microsoft Office
content has been modified. Changes within these ranges will be lost when the
content is refreshed or modified. If you wish to insert your own data or
formulas, reference the content from another location instead of inserting
within the content area.

Even after you click OK to acknowledge and close the message, the message continues to pop-up each time you try to write in a cell. Previously, this warning appeared only one time.

To prevent this message from appearing, you can add an option to the SAS.OfficeAddin.dll.config file for the SAS Add-in for Microsoft Office.

The SAS.OfficeAddin.dll.config file is not created by default, but you might have created one to resolve a different issue. If the file exists, then open it in a text editor. If it does not exist, then use a text editor to create one. The file must be saved in the SAS Add-In installation directory, typically C:\Program Files\SAS\Add-InForMicrosoftOffice\4.3.

For an existing file, add the following option within the <assemblySettings> tag.

<add key="SkipContentRangeChangeCheck" value="true"/>

If the file already exists at your site, you might have other settings within the <assemblySettings> tag. You can add the above option within the existing tag with the other settings already specified.

For a new file, insert the following content into the file:

<configuration>
    <assemblySettings> 
        <add key="SkipContentRangeChangeCheck" value="true"/>
    </assemblySettings> 
</configuration> 

The default value for this configuration option is "false".