Facing problem while uploading a Macro enabled spreadsheet on Sharepoint

[TheCarter]

We have Excel 2007 (xlsm) files which use Addin(xla). On the sharepoint server, we registered them and they open fine when we are logged on to the sharepoint server. But, when we uploaded the xlsm file to Sharepoint site (2007) Issue: None of the users are able to open the xlsm files , Error "Unable to find the function" this function lives in the Addin. How to register xla so that xlsm files which use Addin to Sharepoint Site work.

[Shurod]

I have encountered a problem when importing an Excel spreadsheet to SharePoint. I also want to share the same in case anyone encounters the same problem. Imagine that we have listed and columns of data in Microsoft

• Excel 2007 and we want to add it to a SharePoint list.
• The process is as follows:
• First create the Excel sheet and save it to disk.
• Will close Excel and then will turn to SharePoint, and with sufficient privileges, create a new list of type Import Spreadsheet under Custom Lists group.
• Give a name to the list of Import Spreadsheet type, and select the sheet cáclulo Microsoft Excel that we created earlier.
• Finally press the button Import to import Excel data to SharePoint.
• At this point, we find that the import process is done correctly (than expected), or we can get the error "Method 'Post' of object 'IOWSPostData' failed."
• This error is given by Excel, and the culprit is the file EXPTOOWS.XLA is responsible for executing the import action from Excel to SharePoint and which is normally found in the folder C: \ Program Files \ Microsoft Office \ Office12 \ 1033, but depend on the route and the language version of Microsoft Office 2007 you have.
• Note: Before proceeding, we will make a backup of the file EXPTOOWS.XLA. To resolve this problem, we can double click this file, open it in Excel and select Enable Macros if you tell us a security warning window, and place ourselves in the Add-Ins tab. Then, we will press the Alt + F11 to open the Visual Basic macros. Then will press Ctrl + F to open the search window and look for the string "LVER = Application.SharePointVersion (URL)" throughout the project. Once found inside the method "Sub Initialize (List, Title, URL, QuickLaunch)", discuss this statement and add the following: LVER = 2. Will save the code by clicking on the Save, and close the Visual Basic and Excel.

[Erakna]

Try to read the below links to get more info on uploading files on Sharepoint. There can be some issue with macros or the files which is causing the failure. Try back with some manipulation after reading the the below resources.

Can't upload documents in Sharepoint Services 3.0 (WSS 3.0)

Types of files that cannot be added to a list or library