Display Workbook In Excel Web Access. This is purely an enquiry facility the users do not need any excel. Quick Access Toolbar settings can be accessed using any of the three approaches below.
You cannot display a workbook in an Excel Web Access Web Part unless it is already published to a trusted library. In this example I have selected the following Excel file. Begin with a SharePoint page open for editing and an empty.
Save the page you can see as shown below.
The code sample uses two text boxes a progress bar and a button. But once I have this on my form I am at a loss as to how I can open an excel. In the empty Excel Web Access Web Part in the Select a Workbook section click the hypertext that says Click here to. You can see that different parts of the sheet are displayed here.
