Type – Controls what presentation format a view runs in by default. Set to Viewer for the view to display in the traditional grid format. Set to Excel to have the view open as an MS Excel file.

Prompt – Use to set up the view such that users will be prompted to choose the presentation format for displaying view results each time they run the view. This is done by setting the Prompt property to Yes. The View Prompt window will display each time users run the view, and they can use the Presentation section in that window to choose the presentation format. If the option is No, the view will run in the format you selected for the Type property without any prompt.