Our group is trying to find a solution to this question as well. We have many Excel workbooks that use tables or pivots that link to SAS data. Whenever one the following events happen, significant (re)work is required to reconnect the exhibit and fix/rebuild the pivot tables. The underlying data is changed (i.e. data elements are added/changed) Name of data table changes Location of data changes Server changes/updates We are about to migrate to a different server; so a solution to this issue would be greatly appreciated. Thanks, Jon
... View more