How to change Excel Web Access web part title

Today I came across a very small but very intersting stuff and I really didn’t aware abot this setting.

One of my user wanted to change the title of excel web access web part We changed it from Appearance > Title but it always took “ Excel Web Access – Title “ which really irritated me

But finally I got the clue where to get this done as below

• Click on Modify Shared Web Part
• Under Toolbar and Title Bar uncheck Auto generate Web Part Title option and then change the name from Appearace > Title

 

• This will allow you to change the web part title

 Hope this helps

Excel file is opening with “Unable to Load Workbook” in browser

Error: Unable to Load Workbook
The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:

Comments, ActiveX controls, Shapes, Text Boxes, Pictures, WordArt, Clip Art, Embedded OLE objects, Ink Annotations, Forms Toolbar controls, Control Toolbox controls, Charts that are part of a group, Signature Lines, or Camera objects

Contact the workbook author.

Learn more about what features are not supported by Excel Services…

I removed Text Boxes, Clip Arts, Shapes but no luck still got the same error.

Also removed formulas but error remained same. Followed all possible ways to get rid of this error and checked for all possible root causes mentioned in above error but did not get success.

Finally found one column using a formula “SUMPRODUCT” and it was referring another excel sheet.

Copied data of that column pasted it as a value and removed formula.

Saved the file

Uploaded again it to document library

And then we were able to view that excel file in browser.