I created a protected, macro enabled, .xlsm workbook on excel 2010 that is meant to be edited by many people. I uploaded it on my company's SharePoint site (Not sure if it is 2010 or 2013, I can't find anything that specifies) so that everyone can access it and check it out and make edits. Some people still have office 2010 and some have been upgraded to 2013 but the people with 2013 have not been able to open the workbook and be able to edit. Every time the 2013 people try to open the file (even when I right click and choose "Open in Microsoft Excel"), it tries to open in the browser anyway and fails because the file is protected and contains vba. It works fine for the people who still have office 2010.
I have already changed the library settings to only open in client application but it still doesn't work for excel 2013 people
I do not think I will be able to get administrative access (I am an owner of a site tho) so I don't think I can get to the Central Administration site (to my knowledge, anyway). Are there any other settings I need to change? It is very frustrating that it works and opens in Excel 2010 but refuses to in 2013. I have done some extensive research online but have not found anything that works for 2010 and not 2013.
If there are any work-arounds or anything I am forgetting to do I would greatly appreciate it.
Edit: For the record, I am also using 32 bit IE because I have already picked up that it doesn't work for ANYONE on chrome or 64 bit IE.