I achieve this in a different way.
Once I have saved the view i open Excel and under the DATA heading in the main menu, you will see Import External Data from this select New Database Query. This will bring up a list of all of the databases you can access.
Select the database you require, and a list of all of the table and views will appear, if you do not see the views, click the option button below which has a tick box to display them. Select the view you require and open it, and pass across the fields you wich to see.
Follow through the NEXT buttons, these offer you additional options of sorting and filtering, when you get to finish, make sure Return Data to Excel is selected and select the cell where you wish your results to start.
Once all the data has appeared, at any time you can right mouse click on any cell containing your results and select Refresh Data, from that same list you can also select Data Range Properties that will provide you with many other options, such as Refresh on Opening, fill down adjacent formulas, keep cell formatting etc