SharePoint Excel Web Services - How do I adjust the Zoom Level

Question

_{Thursday, September 9, 2010 11:09 PM}

Hello,

My Organization is using SharePoint 2010 and the Excel Web services module is installed.  The spreadsheet I am using loads perfectly on the page exept for one problem, the zoom level is at about 150% and I can't figure out how to zoom out.  Is there somebody out there that can please help me with this. 

Thank you

All replies (6)

_{Friday, February 18, 2011 5:22 PM}

Hello,

Were you ever able to solve the zoom level problem?

Thanks.

Nik

_{Thursday, March 31, 2011 1:05 AM}

Hi all,

Anyone able to solve this problem? I have the same problem too.

_{Thursday, May 10, 2012 7:26 AM | 1 vote}

Hi all,

For now, you can do the following:

1. Open the file in Excel

2. Decrease the Font Size for all document, you can set it to less than 8 for example 7 or 6

3. Adjust columns and rows according to the Font size

4. Publish your Document.

If the Zoom is still big in the browser, than repeat from point 2, by decreasing again to 5 or 4 and adjut rows and column

If it become very small, than from point 2 increase the font Size and adjut rows and columns.

Note that the ZOOM of Excel Service depend on row heigh and Column width.

Ferdhy Ferdinet

_{Friday, September 19, 2014 1:24 PM}

Thanks for this answer.  This is pretty user-unfriendly, though.  Any chance Microsoft can improve Excel Web Services in SharePoint with the next release by allowing the adjustment of the zoom?

Suggestions:

1. Set the zoom in SharePoint to match the Excel Workbook initially
2. Allow the user to adjust the zoom as he/she sees fit on the web page for each sheet

My use case is a set of dashboards in an Excel work book with interactive pivot charts.  To really make it valuable this is needed.  The whole reason we want it in SharePoint is to provide visbility, improve accessibility and make it user-friendly.  Until it meets those conditions it isn't very useful.

Thanks!

_{Thursday, February 11, 2016 2:20 PM}

I agree, has anyone found a better solution to this problem in the last 18 months?

Thanks
Ed

_{Saturday, May 12, 2018 3:27 PM}

The browser zoom works fine for me PC ctrl and + or zoom out: ctrl and -
The best solution, however, is to upload excel file and create a Google sheet. It is much more user friendly.