Excel 2007 "Trusted Locations"

J

John Aldrich

Is there any way to get Excel 2007 to let you use removable media as a
"trusted location"? My assistant has a Zip drive hooked to her PC that
she's using as basically an external hard drive, but whenever she opens a
saved spreadsheet, it always gives her a warning about "external content
disabled." I wanted to set that as a trusted location, but Excel won't
let me. It gives me an error "The location you have entered is not a
valid location or cannot be used as a Trusted Location for security
reasons; please check the path you have typed or choose another location
or a specific folder."

Is there any way to force Excel to allow it?

Email replies accepted to (e-mail address removed)
 
J

Jim Rech

Does selecting "Allow trusted locations on my network" at the bottom of the
dialog allow you to make the zip drive trusted?

--
Jim
| Is there any way to get Excel 2007 to let you use removable media as a
| "trusted location"? My assistant has a Zip drive hooked to her PC that
| she's using as basically an external hard drive, but whenever she opens a
| saved spreadsheet, it always gives her a warning about "external content
| disabled." I wanted to set that as a trusted location, but Excel won't
| let me. It gives me an error "The location you have entered is not a
| valid location or cannot be used as a Trusted Location for security
| reasons; please check the path you have typed or choose another location
| or a specific folder."
|
| Is there any way to force Excel to allow it?
|
| Email replies accepted to (e-mail address removed)
 
J

John Aldrich

Does selecting "Allow trusted locations on my network" at the bottom of
the dialog allow you to make the zip drive trusted?
Thought that might do it, but no, it doesn't. :-( Thanks for the
suggestion... any other suggestions? I'm no excel guru, that's why I'm
posting in here. :)
 
B

Bob I

FWIW, anyone who supports Office applications would/should strongly
recommend again directly working from removable media. Office 2007 just
enforces it.
 
J

Jim Rech

any other suggestions?

I tried to simulate your situation by using a USB drive. It was drive F:. I
found Excel would not let me make the root trusted (F:\) but it did allow a
sub folder ("F:\TestDir"). I had the network option selected at the time I
tried a subfolder so I don't know whether if it would have worked without
it. I don't know whether you were trying just the root so I thought I
mention this.

--
Jim
| On Wed, 05 Nov 2008 16:36:25 -0500, Jim Rech wrote:
|
| > Does selecting "Allow trusted locations on my network" at the bottom of
| > the dialog allow you to make the zip drive trusted?
| >
| Thought that might do it, but no, it doesn't. :-( Thanks for the
| suggestion... any other suggestions? I'm no excel guru, that's why I'm
| posting in here. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top