Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 113
Default unable to read file

I just finished a spreadsheet last night that was opened from a flash/jump
drive and saved back on it after editing. I took the drive to work and now
it is saying that is a unable to read file. So I brought the drive back home
and it still won't open--saving unable to read file. Please help!
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11
Default unable to read file

Jessica,

I hate to have to break this to you, but if my suspicion is correct,
then you have lost your file...
The standard USB disk driver has a setting for letting you select
between performance or quick removal optimization; in plain English,
because writing to memory is much faster than writing to the flash disk,
you are given the option of writing to the memory first, and then to the
flash disk (in the background), so you are not made to wait while
writing to the flash disk; the risk here (and my suspected cause of your
problem) is that if you save and pull out the flash disk right
afterwards, you have actually saved to the computer memory, but haven't
given the computer the time to complete the save to the disk (which it
will do when it gets a low activity interval, not necessarily right
away)... you just pull the jump off too early, while the system still
has the file open, so it gets corrupted. To avoid this, you need to
manually stop the device before removing (option given on the icon in
the system tray), when Optimize for Performance is selected.
I have been using jumps since a 128MB one costed three times what a 1GB
one costs today, and have always preferred the Optimize for Quick
Removal option, which forces the operating system to write directly to
the jump drive; the penalty is a small delay in saving, but IMHO
negligible compared to the benefit of not risking file corruption.
To check/change your setting: from My Computer, right-click on the jump
drive and select Properties; then, on tab Hardware, select the jump
drive again (it shows all drives again) and click on the Properties
button; what you're looking for is on the Policies tab of the new pop-up
window.

HTH,
Nikos
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 90
Default unable to read file

Never open a file that is on removable media. Never save a file to removable
media. Always copy it to your hard drive with Windows Explorer first. Use
the same method when finished. As you've learned the hard way, you can end
up with corrupt files if you don't.


--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"jessica" wrote in message
...
I just finished a spreadsheet last night that was opened from a flash/jump
drive and saved back on it after editing. I took the drive to work and
now
it is saying that is a unable to read file. So I brought the drive back
home
and it still won't open--saving unable to read file. Please help!



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11
Default unable to read file

JoAnn,

Never is a strong word, perhaps too strong sometimes! One of the uses of
flash disks is so sensitive files are not left behind on hard disks,
on PC's where prying eyes might gain access (like at work)... there are
tools out there that can recover files even from a formatted HDD.

Nikos
  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 90
Default unable to read file

I know that "never" is a strong word, as is "always", but sometimes it
applies. If you have a file that is so sensitive that you do not want to
leave a trace of it behind on a computer, NEVER use that computer to open
that file. Seems pretty simple to me. <shrug

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"Nikos Yannacopoulos" wrote in message
...
JoAnn,

Never is a strong word, perhaps too strong sometimes! One of the uses of
flash disks is so sensitive files are not left behind on hard disks, on
PC's where prying eyes might gain access (like at work)... there are tools
out there that can recover files even from a formatted HDD.

Nikos





  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11
Default unable to read file

Well, we've both made our points, and it seems to be a personal judgment
question after all... I rest my case.

Regards,
Nikos
  #7   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default unable to read file

Jessica..........I use Flash/Jump drives all the time, working directly to
and from them constantly and have never had a problem losing a file.
Sometimes, however, when I do a SaveAs, and change the name of the file, the
computer will divert the save to the C drive (default directory)rather than
putting it where I got it off my JumpDrive. Go home, and do a search of your
computer by the FileName, or parts thereof, and it may show up as being
stashed somewhere else..........

hth
Vaya Con Dios,
Chuck, CABGx3



"jessica" wrote:

I just finished a spreadsheet last night that was opened from a flash/jump
drive and saved back on it after editing. I took the drive to work and now
it is saying that is a unable to read file. So I brought the drive back home
and it still won't open--saving unable to read file. Please help!

  #8   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,365
Default unable to read file

Glad to hear someone else makes this kind of use of flash drives also. I've
got a 4GB drive pretty much full of work I drag back and forth between home
and office - and often work from directly on the flash drive. One Excel file
on it is well over a year old and has probably been accessed daily with
updates daily.

Jessica, I hope CLR's suggestion pans out for you. I think what Nikos
Yannacopoulos wrote in his first post is probably on-point: make sure that
you 'eject' or use the [Safely Remove Hardware] feature before unplugging a
USB device. After using that feature, wait long enough for the cache to get
flushed and for the file to be written completely to the USB device - you can
usually tell when it has finished by just watching the indicator light on the
device or waiting for the [It is safe to Remove...] message from Windows.

"CLR" wrote:

Jessica..........I use Flash/Jump drives all the time, working directly to
and from them constantly and have never had a problem losing a file.
Sometimes, however, when I do a SaveAs, and change the name of the file, the
computer will divert the save to the C drive (default directory)rather than
putting it where I got it off my JumpDrive. Go home, and do a search of your
computer by the FileName, or parts thereof, and it may show up as being
stashed somewhere else..........

hth
Vaya Con Dios,
Chuck, CABGx3



"jessica" wrote:

I just finished a spreadsheet last night that was opened from a flash/jump
drive and saved back on it after editing. I took the drive to work and now
it is saying that is a unable to read file. So I brought the drive back home
and it still won't open--saving unable to read file. Please help!

  #9   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 594
Default unable to read file

Yup, I do use them all the time, and I do mean all the time. I have three
128's a 512, a 4GB and a 6GB and a 40GB. On some, I even have programs,
like Paint Shop Pro, and of course copy of my Personal.xls and lots of
reference material, pictures, songs.........sometimes the noise gets so bad
in the office that I just put on the headphones and play loud music to
myself to drown them out. And they are so easy to swap. What I would
"really" like, would be if I could have my own Operating System and my own
programs all on my own USB drive and walk up to any strange computer and it
would boot and run from my drive and it would feel like home.......On saving
files, I've been snake-bit from Company LAN's going bad so many times that I
usually save my working file to my Jump Drive every hour or so, sometimes
more.......and when things go fruity, I can always walk back through the
saves to find what I did to cause the trouble<g.......anyway.....the jump
drives are not like the old floppies, they work fine and last a long
time.........

Vaya con Dios,
Chuck, CABGx3




"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Glad to hear someone else makes this kind of use of flash drives also.

I've
got a 4GB drive pretty much full of work I drag back and forth between

home
and office - and often work from directly on the flash drive. One Excel

file
on it is well over a year old and has probably been accessed daily with
updates daily.

Jessica, I hope CLR's suggestion pans out for you. I think what Nikos
Yannacopoulos wrote in his first post is probably on-point: make sure that
you 'eject' or use the [Safely Remove Hardware] feature before unplugging

a
USB device. After using that feature, wait long enough for the cache to

get
flushed and for the file to be written completely to the USB device - you

can
usually tell when it has finished by just watching the indicator light on

the
device or waiting for the [It is safe to Remove...] message from Windows.

"CLR" wrote:

Jessica..........I use Flash/Jump drives all the time, working directly

to
and from them constantly and have never had a problem losing a file.
Sometimes, however, when I do a SaveAs, and change the name of the file,

the
computer will divert the save to the C drive (default directory)rather

than
putting it where I got it off my JumpDrive. Go home, and do a search of

your
computer by the FileName, or parts thereof, and it may show up as being
stashed somewhere else..........

hth
Vaya Con Dios,
Chuck, CABGx3



"jessica" wrote:

I just finished a spreadsheet last night that was opened from a

flash/jump
drive and saved back on it after editing. I took the drive to work

and now
it is saying that is a unable to read file. So I brought the drive

back home
and it still won't open--saving unable to read file. Please help!



  #10   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 37
Default unable to read file

It is possible to boot from a USB flash drive on some PC's. It has to be
selected as an option in the BIOS setup program.


"CLR" wrote in message
...
.... And they are so easy to swap. What I would
"really" like, would be if I could have my own Operating System and my own
programs all on my own USB drive and walk up to any strange computer and
it
would boot and run from my drive and it would feel like home....... Vaya
con Dios,
Chuck, CABGx3



"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Glad to hear someone else makes this kind of use of flash drives also.

I've
got a 4GB drive pretty much full of work I drag back and forth between

home
and office - and often work from directly on the flash drive. One Excel

file
on it is well over a year old and has probably been accessed daily with
updates daily.

Jessica, I hope CLR's suggestion pans out for you. I think what Nikos
Yannacopoulos wrote in his first post is probably on-point: make sure
that
you 'eject' or use the [Safely Remove Hardware] feature before unplugging

a
USB device. After using that feature, wait long enough for the cache to

get
flushed and for the file to be written completely to the USB device - you

can
usually tell when it has finished by just watching the indicator light on

the
device or waiting for the [It is safe to Remove...] message from Windows.

"CLR" wrote:

Jessica..........I use Flash/Jump drives all the time, working directly

to
and from them constantly and have never had a problem losing a file.
Sometimes, however, when I do a SaveAs, and change the name of the
file,

the
computer will divert the save to the C drive (default directory)rather

than
putting it where I got it off my JumpDrive. Go home, and do a search
of

your
computer by the FileName, or parts thereof, and it may show up as
being
stashed somewhere else..........

hth
Vaya Con Dios,
Chuck, CABGx3



"jessica" wrote:

I just finished a spreadsheet last night that was opened from a

flash/jump
drive and saved back on it after editing. I took the drive to work

and now
it is saying that is a unable to read file. So I brought the drive

back home
and it still won't open--saving unable to read file. Please help!








  #11   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 594
Default unable to read file

I've heard that David, but have never experienced it yet. Probably it is
another one of the things that the MIS dept can lock me out
of...........<sigh

Vaya con Dios,
Chuck, CABGx3





"David F Cox" wrote in message
...
It is possible to boot from a USB flash drive on some PC's. It has to be
selected as an option in the BIOS setup program.


"CLR" wrote in message
...
.... And they are so easy to swap. What I would
"really" like, would be if I could have my own Operating System and my

own
programs all on my own USB drive and walk up to any strange computer and
it
would boot and run from my drive and it would feel like home.......

Vaya
con Dios,
Chuck, CABGx3



"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Glad to hear someone else makes this kind of use of flash drives also.

I've
got a 4GB drive pretty much full of work I drag back and forth between

home
and office - and often work from directly on the flash drive. One

Excel
file
on it is well over a year old and has probably been accessed daily with
updates daily.

Jessica, I hope CLR's suggestion pans out for you. I think what Nikos
Yannacopoulos wrote in his first post is probably on-point: make sure
that
you 'eject' or use the [Safely Remove Hardware] feature before

unplugging
a
USB device. After using that feature, wait long enough for the cache

to
get
flushed and for the file to be written completely to the USB device -

you
can
usually tell when it has finished by just watching the indicator light

on
the
device or waiting for the [It is safe to Remove...] message from

Windows.

"CLR" wrote:

Jessica..........I use Flash/Jump drives all the time, working

directly
to
and from them constantly and have never had a problem losing a file.
Sometimes, however, when I do a SaveAs, and change the name of the
file,

the
computer will divert the save to the C drive (default

directory)rather
than
putting it where I got it off my JumpDrive. Go home, and do a search
of

your
computer by the FileName, or parts thereof, and it may show up as
being
stashed somewhere else..........

hth
Vaya Con Dios,
Chuck, CABGx3



"jessica" wrote:

I just finished a spreadsheet last night that was opened from a

flash/jump
drive and saved back on it after editing. I took the drive to work

and now
it is saying that is a unable to read file. So I brought the drive

back home
and it still won't open--saving unable to read file. Please help!








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to open excel file jjuan New Users to Excel 5 September 12th 06 12:19 PM
Unable to Read File steenman2 Links and Linking in Excel 1 July 22nd 06 07:33 AM
Unable to read file steenman2 Excel Worksheet Functions 0 July 21st 06 02:44 PM
Unable to Read File steenman2 Excel Discussion (Misc queries) 0 July 21st 06 02:43 PM
Unable to read file Dave Hall Setting up and Configuration of Excel 0 December 2nd 04 06:32 AM


All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"