need to link display a specific workbook in the Excel Web access web part. If I enter the URL of the spreadsheet, which is in the Sharepoint site, the first workheet displays properly. If I add #Sheet2 after the file name I get "Unable to Load Workbook. Excel Services was unable to load the workbook that you requested." This works: http://sharepointserver.com/Library/File.xlsThis does not: http://sharepointserver.com/Library/File.xls#Sheet2
I found out I have to publish to Excel Services to use the Named Items.