Object or Database read only error message when attempting to connect to xlsm file on sharepoint.

Question

I need to combine spreadsheets (all that share the exact same column headers) into power pivot.

I created a connection using these instructions http://blog.contextures.com/archives/2010/09/06/powerpivot-from-identical-excel-files/, but when I attempt to import the data into powerpivot I get an error message stating that I the object or db is readonly.

This is what I have in the connection string.  (The mode WAS Share Deny Write, but I have since changed to READWRITE.  Still, no dice.)

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Users\zblumm\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.MSO\1CB9D4FB.xlsm;Mode=READWRITE;Extended Properties="HDR=YES;";Jet OLEDB:System database=;Jet OLEDB:Registry Path=;Jet OLEDB:Engine Type=37;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=True;Password=**********;Jet OLEDB:Database Password=**********

Any thoughts on how to get around this? 

I have full permission on the file and the document store in sharepoint

The file itself is not read only.

Thanks,

Melissa

Answer 1

Excel files containing code do not work on Sharepoint.

Answer 2

I have an automated report on sharepoint that works great and I use it all the time.