Trusted location on a Sharepoint server

[CHSLax60]

I have files that multiple people need to open and I need to make sure that a marcro runs when they do. I tried to set the files' location as a trusted location but it doesn't seem to be working.

The only thing I can think of is that maybe it's because the folder where the files are, is on an internal Sharepoint site. Could that be why it's not working? Does excel not allow http:// addresses as trusted locations?

 

[stwpkcmo]

I know I was having a similar problem with excel and sharepoint . . . my solutions was to set my excel to work from the desktop instead of the sharepoint draft folder on the computer:
Open blank Excel > Click Office Button > Select Excel Options > Select the Save tab > Select "The web server" radio button for the Offline editing options for document management server files > Select OK > OK to the popup > Close Excel

Not sure if this is the best method, but it worked for my team . . .