[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

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 all...my 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
  • 2
1 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.
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 :-(

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now