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

Posted on 2014-07-17
Last Modified: 2014-07-24
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
Question by:agwalsh
    LVL 9

    Accepted Solution

    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.

    Author Comment

    I've passed on that suggestion. He hasn't come back to me. Let's consider it solved.

    Author Closing Comment

    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 :-(

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
    The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now