How to automatically refresh external data in excel 2011/osx?

I have an excel spreadsheet that is pulling in data from an external CSV. I want it to refresh every time I open it, because eventually it's going to be pulling data in from 20 different files. At the moment it says

security warning "data connections have been disabled"

And then when I override it, it prompts me to reselect the file in the finder.

It sounds like this is pretty easy in windows excel, prettymuch just enabled a setting in the 'Trust Center'. Only excel 2011 has no trust center...and as far as I can tell, no way to actually do this automagically =)