Auto Updating Queries on Open

[FKoenig]

So I have an excel file with a pivot attached to a query which is set to auto-update when the file is opened.

When I open the file (Excel 2010), Excel asks me if I want to allow updates. Whe a coworker opens the file (Excel 2007), it does not.

I'm tempted to think this is an issue with the security level settings on our two different machines, rather than a versioning issue... but I can't seem to find the option/setting in Excel '07 to turn up the security.

What say the geniuses of Mr. Excel.com?

 

[taurean]

Take a look at the colleague's Excel Options Settings i.e.
Office Button (@ Left Top) >> Excel Options >> Trust Center >> Trust Center settings!

 

[FKoenig]

That's exactly what it was... he had the entire network drive listed as a trusted location. *tsk tsk tsk*

Was just coming back here to say "nevermind".....thank you very much for the help!