Excel 2007 "Trusted Locations"

[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)

 

[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)

 

[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.

 

[Bob I]

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

 

[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.