View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default transfer exel report to a usb flash drive F

I, too, have it set for Quick Removal. But I still use the system tray icon.

(lack of faith???)

JLatham wrote:

Thanks to both of you for that insight. I understand the logic perfectly -
and those are reasonable concerns. I know what a disaster it can be if you
forget to properly 'eject' a USB drive without flushing the buffers.

My safeguards? Caution. 16GB Flash drive (3.5 GB in use, 11.5 available) -
I drag stuff back and forth between home/work with this rascal.

One final 'tweak' I make on the connection to this particular device, which
is what can make it slow when working with it, but adds a little safety to
even accidentally removing it: I have it "optimized for quick removal" which
means that the writes to it are not cached by Windows, but happen in real
time. A performance hit, but less risk of loss by accidentally removing it.
The option info even states "...you can disconnect this device without using
the Safe Removal icon." Although I always use that anyhow.

To get the My Computer | Right-click on the device/drive and choose
[Properties] then to the Hardware tab and pick the device from the list in it
and click the [Properties] button on that tab. Next window that opens,
choose the [Policies] tab and there are 2 options available: Optimize for
Quick Removal, and (the default) Optimize for Performance.

The default Optimize for Performance *requires* you to use the Safe Removal
icon or otherwise 'eject' the device or else you risk file corruption/loss if
the Windows cache buffer hasn't been flushed.

Again, thanks for the info - valuable, and I agree that your recommendations
ARE the wise ones to offer to others as they are more likely to keep one and
all out of trouble in more than one way :-)

"Dave Peterson" wrote:

I recommend never opening a file from any removeable media--just because it
could be removed and screw up when I try to save it.

And I recommend not saving directly to the flashdrive (or any removeable media)
for the same reasons Ragdyer stated--albeit, they amount of space available
isn't as big a concern as with floppies.

But by saving to the harddrive first and copying to the flash drive, I know that
I have a backup.

I guess I just don't trust those things enough to use them directly (and for the
only copy).

This is more of a gut feeling than anything else for me. But as a general
recommendation to others, I think it's a reasonable approach.





JLatham wrote:

Curiosity question: I've seen others recommend not working directly to/from
USB Flash drive also. Why not?

I often do it and haven't lost anything - slow as snails swimming in
molasses some times, but no corrupted files or anything.

"Ragdyer" wrote:

*SAVE* to your hard drive,
THEN,
Use Windows explorer to *COPY* to the flash drive!

*DON'T* save to the flash drive!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rexdaleyou" wrote in message
...
transfer exel doc.to new flash drive 2.0




--

Dave Peterson


--

Dave Peterson