how to copy data from SQL Server table to excel Spreadsheet thru Linked Servers
I think you are looking at this from the wrong point of view.  You don't want SQL to upate your spreadsheet, you want your spreadsheet to connect to your database and get the latest data.  

Create a local DSN  -- using "setup data sources (ODBC) -- then connect to that data source from excel.