I'd like to disable the Query Refresh box that pops up when opening one of
our planning files, to avoid consusing the less excel savvy people who will
be using it. Any tips on how to do this?

Thanks!
Britt

This should do the trick. But you'd have to make the change on the machines
of people receiving the file. Also, it does lower the security level by
automatically running all web queries when you open the workbook. I'm not
sure there is a way to do it on a per/workbook basis.

http://support.microsoft.com/default.aspx?id=248204

Be careful when editing the registry.

"blonde1030" wrote:

I'd like to disable the Query Refresh box that pops up when opening one of
our planning files, to avoid consusing the less excel savvy people who will
be using it. Any tips on how to do this?

Thanks!
Britt