Excel 2007 "security alert - data connection" message every time?

Every time I open a spreadsheet or workbook that has links to other workbooks I am notified by the message bar that content has been blocked. I click Options > Enable this content > OK. Even if I don't make any changes I'm prompted to save changes when I close the file. If I hit Yes or if I hit No, I will still be prompted to enable content in the message bar the next time I open the same file.

I have changed the External Content settings in the Trust Center to "Enable all data connections (not recommended)" and "Enable automatic update for all workbook links (not recommended)" but I still get the messages.

My Message Bar is set to "Show the message bar in all applications when content is blocked" because I read on Microsoft KB that the other option of "never show information about blocked content" will still block the content, just not tell you about it, which doesn't fix my issue.

The files I'm opening and the files linked to and from them are all on the same shared drive on a file server in the office. Is there a way to tell Office '07 that our file drive is a trusted source by default?

I am on Win7 SP1 64bit, and thank you for any responses!

Open the "Trust Center" in Excel.
Click on "Trust Center Settings"
Select the "Trusted Locations" menu
Add new location - Add your network drive here as a trusted location.
Check the box that says "Allow trusted locations on my network (not recommended)"

That should do it!

yes! that did it, i feel stupid for not noticing that. It still asks me to save changes even if i didnt do anything, even if i didnt even click into it, but that's a question for another thread i suppose. Thank you!