The Table Analysis Tools Add-in for Excel 2010 cannot function without a connection to a SQL Server 2008 (or later) Analysis ...

The Table Analysis Tools Add-in for Excel 2010 cannot function without a connection to a SQL Server 2008 (or later) Analysis Services instance that allows the creation of temporary models. Temporary models are deleted from the instance when the user closes their connection.