Sorry, no help there - I don't use VPN and am totally unfamiliar with its
limitations. But since, in effect, you are using the system at your office I
can kind of see why it wouldn't see a USB device on your home system. I'm
wondering if you couldn't try mapping your local machine in by adding it as a
network location -- but perhaps not. Just spit-balling, as I said, I'm
pretty much totally ignorant of VPN use/features and work-arounds.

I'm wondering, on the email thing, what format you send your email as; HTML,
RTF or plain text. I do all of mine as plain text to keep from embedding
files within the body of the email and so they are always just an attachment,
not any part of the email itself.

If the problem continues to be a problem, you might ask about it over in the
Outlook group - they may be more knowledgable about that strange behavior
than we generally are here in the Excel groups?

"Jane" wrote:

I email as you do. I do have a jump drive but I access my work files on my
laptop at home using VPN. The odd thing is that if I insert a jump drive in
my laptop, I can not access that drive since I am accessing my work's system.
any ieas on that angle?

"JLatham" wrote:

I'm not sure what process you're using to email and open the files.

I usually send my files to myself via email by first starting an email and
then using Insert | File and attach the .xls file. When I get the email at
the other end, I simply open the email and use Save Attachments to save them
to a location on the computer at the receiving end. No formulas get changed
for me.

Ever consider just getting a little USB thumb drive to haul them back and
forth on?

"Jane" wrote:

I know how to lock cells... my question is:

I have vlookup formulas in a document that I emailed from work to my home
email address. At hoem, the formula now includes the temp email file
location.

I need to be able to send files home and then back to work without having
the vlookup formulas change.

help please... jane