Answered by:
Cannot upload xlsm files on SharePoint

Question
-
Hi everyone
I have a problem on SharePoint 2013 Foundation. I cannot upload xlsm Excel files (excel with Macro) on a document library. I can upload through Windows Explorer but then the file becomes corrupted. Normal Excel and other file formats can be normaly uploaded.
I appreciate every help.
Thursday, July 24, 2014 12:55 PM
Answers
All replies
-
Hi,
According to your post, my understanding is that you couldn’t upload the .xlsm excel files with Macro into a document library on SharePoint 2013 Foundation.
In my environment, I tried to upload an .xlsm excel files with Macro in a document library. The result was that the .xlsm excel files could be uploaded, edited and saved.
And, when I viewed these files in a browser window, I could edit them, however the Macro would not be supported in the browser window.I recommend that you can check if the “Define blocked file types” in General Security of Central Administrator includes the .xlsm file type at first.
And, you can try to upload a new .xlsm excel file to the library or upload it into another document library in your environment.
For more information, you can refer to:
http://office.microsoft.com/en-us/sharepoint-server-help/differences-between-using-a-workbook-in-the-browser-and-in-excel-HA010369179.aspx
http://technet.microsoft.com/en-us/library/cc262496(v=office.15).aspxBest Regards,
Linda Li
Linda Li
TechNet Community SupportFriday, July 25, 2014 8:24 AM -
The xlsm filetype is not on the list of blocked file types. I even tried to upload it as an attachment on a list but it didn't work. I tried to upload it on several Document Library but I always get the same error. Could it be a server issue.
Friday, July 25, 2014 12:17 PM -
Friday, August 1, 2014 6:48 AM