Help states:

"You can export a View's data to Excel for further use. To do so, select Export to | xDirect from the File menu, or click the Excel Direct button in the toolbar. You'll be prompted for the location and file name for the Excel (.xls) file. Select the appropriate drive, directory, and file name and click Save."

I am never presented with this option. Instead, Excel opens and the data is placed in a new sheet. Is there a command switch to enable this option? (I couldn't find one.)

Thanks

Hi Mike,

Sorry, the Help is incorrect (it was probably copied from the old Export to Excel menu choice).

We have always felt it is more useful to open up the sheet and let the user decide whether to keep the result or not. You can set the default File | Save as... location in Excel.

You can also automate the export to Excel using the /XD command line parameter. There are a set of rules about where the .XLS(X) file ends up. The command line parameters are documented in the Help.