Changing from Excel 2003 to 2007, same file, accessing from different computers...issues

hi Folks
I have a customer who is just transitioning from 2003 to 2007. His issue is with the security prompt he gets when he (or one of his staff members) accesses the same file from different computers. He is complaining that he gets a security message every time this happens..i.e. one person accesses filex on computer 1. They fix this security setting. Then the same person accesses filex on computer 2 and gets the same warning again. He wants to know if there is any way to fix it once and for own view is that he's going to have to suck it up and change them every time..but I'd like to see if there is another way around this..thanks as always
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I'm assuming you are talking about the "Open File security warning".

What you can do is change your security settings for the local intranet:

1.  Open Internet Options (through IE or the control panel).
2.  Select "Security" tab.
3.  Select "Local intranet" and click sites.
4.  Even though it says "automatically detect intranet", it doesn't always work, so you have to manually add the computer(s) to the intranet list.  Click Advanced.
5.  To add a computer, type file://<computer name> under "Add this website to the zone:" and click Add.

Now, you've added that machine to the intranet zone, and you shouldn't get those prompts.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
agwalshAuthor Commented:
I've passed on that suggestion. He hasn't come back to me. Let's consider it solved.
agwalshAuthor Commented:
Not sure if it worked or not because the person who asked me to look into it didn't give me any feedback on it :-(
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.