SharePoint Slow Performance or Size Warning on Excel Files

Symptoms: Users report slow upload or download of Excel Files, or report that SharePoint refuses to upload an Excel file, prompting the user to save the file locally instead.

Cause: Formatting or adding formulas to whole rows or columns causes Excel to recalculate or reformat thousands of empty cells on each save and makes the size of the Excel file grow exponentially. While technically not a SharePoint issue, users first notice the disproportionate file growth when the workbook size reaches a point that causes performance issues when communicating with the SharePoint server or when the default SharePoint upload limit of 50MB is exceeded.

Solution: Clear unneeded formatting and calculations from the workbook’s empty rows, as described in this post http://www.spreadsheetshoppe.com/2/post/2012/01/how-to-reduce-excel-file-size.html. Users may also wish to save the file as an ODR file, which will remove the blank cells. The user can then save the file back as an xlsx with the same file name. In one instance, the size of the workbook was reduced from 52MB to 235K.

Advertisements

About Joy Lavigne (Adkins)

SharePoint Administrator for a mid-sized organization. Frequent speaker at SharePoint Saturday events. Teller of terribly corny jokes. View all posts by Joy Lavigne (Adkins)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: