11-14-2013 06:41 AM
Recently we migrated SAS from 9.1.3 to 9.3. We have a lot of excel templates which we use to refresh on weekly basis.
I am facing issues after migration. There is difference in Server names between two versions. Earlier version has server name as SAS Main and current Version has SASApp. Source in excel is shown as SAS Main:<librayname>.<tablename>. In refresh all tables are failing as there is no server with name SASMain in new version.
My question here is , is there a way to refresh these tables in excel without recreating the template