<div>
<div class="content wysiwyg-content">
...so that the spreadsheet keeps the sort order specified in the View? I see the warning message SS gives about &quot;sorting the query of the View&quot;, but I don't see where to do that. <br />
<br />
In the Connection Properties, I tried changing the Command Type to &quot;SQL&quot; and the Command Text to &quot;SELECT MyView.*... ORDER BY MySort1, MySort2&quot;, but then SS gave me an error message about that no longer matching the odc, and it would be deleted. <br />
<br />
Thanks in advance
</div>
</div>


...so that the spreadsheet keeps the sort order specified in the View? I see the warning message SS gives about "sorting the query of the View", but I don't see where to do that. 

In the Connection Properties, I tried changing the Command Type to "SQL" and the Command Text to "SELECT MyView.*... ORDER BY MySort1, MySort2", but then SS gave me an error message about that no longer matching the odc, and it would be deleted. 

Thanks in advance

How to link Excel to SQL Server View...

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.