Can I save changes to excel on a floppy?

[Martie1949]

I have a monthly expense I set up in excel. I have to go from office to
office to different computers so if I add in an expense can or will the
update be saved in the floppy or how can I save the changes?

 

[JoAnn Paules [MSFT MVP]]

You never open a file on a floppy nor should you ever save a file back to a
floppy.

Insert the floppy, save the file to the hard disk, open the file (on the
hard disk), make your changes, save the file (on the hard disk), close the
file, copy the file back to the floppy, move on to the next office.

Alternate solution - get a network and stay in your own office. ;-)

 

[CLR]

Technically, what you are wanting to do is possible.........however, Floppy
Disk Drives are mechanical devices and therefore inherently subject to
failure which could result in data loss. You would be much better off using
one of the new pocket "jump" drives, they hold a LOT more data than a floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3

 

[JoAnn Paules [MSFT MVP]]

Even then, the file should be saved to the hard disk before changing it.

 

[Don Guillett]

ditto

--
Don Guillett
SalesAid Software
(e-mail address removed)

Even then, the file should be saved to the hard disk before changing it.

--

JoAnn Paules
MVP Microsoft [Publisher]

Technically, what you are wanting to do is possible.........however,
Floppy
Disk Drives are mechanical devices and therefore inherently subject to
failure which could result in data loss. You would be much better off
using
one of the new pocket "jump" drives, they hold a LOT more data than a
floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Pray tell "Why"?................I have personally been working off of
various types of Jump Drives for a couple of years with nary a
problem............I can understand it with Floppies, and I suppose anything
is possible, but I cannot even begin to concieve how working off a
mechanical Hard Drive would be considered more reliable than a solid state
Jump Drive.

A complex technical explanation will suffice.........

Vaya con Dios,
Chuck, CABGx3

Even then, the file should be saved to the hard disk before changing it.

--

JoAnn Paules
MVP Microsoft [Publisher]

Technically, what you are wanting to do is possible.........however,
Floppy
Disk Drives are mechanical devices and therefore inherently subject to
failure which could result in data loss. You would be much better off
using
one of the new pocket "jump" drives, they hold a LOT more data than a
floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Don.........
Please see my response to JoAnn

Vaya con Dios,
Chuck, CABGx3

ditto

--
Don Guillett
SalesAid Software
(e-mail address removed)

Even then, the file should be saved to the hard disk before changing it.

--

JoAnn Paules
MVP Microsoft [Publisher]

Technically, what you are wanting to do is possible.........however,
Floppy
Disk Drives are mechanical devices and therefore inherently subject to
failure which could result in data loss. You would be much better off
using
one of the new pocket "jump" drives, they hold a LOT more data than a
floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3


I have a monthly expense I set up in excel. I have to go from office to
office to different computers so if I add in an expense can or will the
update be saved in the floppy or how can I save the changes?

 

[Dave Peterson]

It's very difficult to remove your harddrive while you're editing the file.

And as large as those jump drives are, there is usually lots more real estate
available on a harddrive.

When excel saves a file, it renames the original file, creates a new file. If
that works ok, it either deletes the original or renames it to something like
"backup of book1.xlk". If you run out of space on that thumb drive, then bad
things can happen.

And a side benefit of saving to a harddrive and copying to the thumb drive is
that you have a backup.

(I bet more thumb drives are just plain lost than desktops or even laptops.)

Pray tell "Why"?................I have personally been working off of
various types of Jump Drives for a couple of years with nary a
problem............I can understand it with Floppies, and I suppose anything
is possible, but I cannot even begin to concieve how working off a
mechanical Hard Drive would be considered more reliable than a solid state
Jump Drive.

A complex technical explanation will suffice.........

Vaya con Dios,
Chuck, CABGx3

Even then, the file should be saved to the hard disk before changing it.

--

JoAnn Paules
MVP Microsoft [Publisher]

Technically, what you are wanting to do is possible.........however,
Floppy
Disk Drives are mechanical devices and therefore inherently subject to
failure which could result in data loss. You would be much better off
using
one of the new pocket "jump" drives, they hold a LOT more data than a
floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3


I have a monthly expense I set up in excel. I have to go from office to
office to different computers so if I add in an expense can or will the
update be saved in the floppy or how can I save the changes?

 

[Dave Peterson]

When excel saves a file, it saves it as a new name first. If that works ok, it
either deletes the original or
renames it to something like "backup of book1.xlk".

And then renames that temporary file to the original file name.

If you run out of space on that thumb drive, then bad things can happen.

It's very difficult to remove your harddrive while you're editing the file.

And as large as those jump drives are, there is usually lots more real estate
available on a harddrive.

When excel saves a file, it renames the original file, creates a new file. If
that works ok, it either deletes the original or renames it to something like
"backup of book1.xlk". If you run out of space on that thumb drive, then bad
things can happen.

And a side benefit of saving to a harddrive and copying to the thumb drive is
that you have a backup.

(I bet more thumb drives are just plain lost than desktops or even laptops.)

Pray tell "Why"?................I have personally been working off of
various types of Jump Drives for a couple of years with nary a
problem............I can understand it with Floppies, and I suppose anything
is possible, but I cannot even begin to concieve how working off a
mechanical Hard Drive would be considered more reliable than a solid state
Jump Drive.

A complex technical explanation will suffice.........

Vaya con Dios,
Chuck, CABGx3

Even then, the file should be saved to the hard disk before changing it.

--

JoAnn Paules
MVP Microsoft [Publisher]



Technically, what you are wanting to do is possible.........however,
Floppy
Disk Drives are mechanical devices and therefore inherently subject to
failure which could result in data loss. You would be much better off
using
one of the new pocket "jump" drives, they hold a LOT more data than a
floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3


I have a monthly expense I set up in excel. I have to go from office to
office to different computers so if I add in an expense can or will the
update be saved in the floppy or how can I save the changes?

 

[CLR]

Uh-huh, uh-huh, and if a hard drive runs out of space, even more "bader"
things will happen, and that's a "for-sure".........but as with anything
else, the JumpDrive must be used within the parameters that exist for it.
NO memory device operates reliably when pushed past it's limit, Hard Drives
included. The JumpDrive is a very effective way of moving files around from
office to office, especially when the offices are not even with the same
company and are not hooked together with a network.......or the network has
so many "MIS monitoring features" on it the computers will hardly run
anyway. Like I said, I have been doing it with 4 different JumpDrives for
a couple of years and no problems........that's not personal opinion, that's
actual FACT.....and the best part is, NOone has access to those files but
ME. As for losing a JumpDrive, or the keys to your car, .......well, thats
not really a legitimate reason for not using JumpDrives or cars either one.
The OP wanted to know about moving files from computer to computer with a
physical device that he could take with him. I've told him of my actual
experience in doing so, and what I think is the best way to do that.

Vaya con Dios,
Chuck, CABGx3

When excel saves a file, it saves it as a new name first. If that works ok, it
either deletes the original or
renames it to something like "backup of book1.xlk".

And then renames that temporary file to the original file name.

If you run out of space on that thumb drive, then bad things can happen.

It's very difficult to remove your harddrive while you're editing the file.

And as large as those jump drives are, there is usually lots more real estate
available on a harddrive.

When excel saves a file, it renames the original file, creates a new file. If
that works ok, it either deletes the original or renames it to something like
"backup of book1.xlk". If you run out of space on that thumb drive, then bad
things can happen.

And a side benefit of saving to a harddrive and copying to the thumb drive is
that you have a backup.

(I bet more thumb drives are just plain lost than desktops or even laptops.)

Pray tell "Why"?................I have personally been working off of
various types of Jump Drives for a couple of years with nary a
problem............I can understand it with Floppies, and I suppose anything
is possible, but I cannot even begin to concieve how working off a
mechanical Hard Drive would be considered more reliable than a solid state
Jump Drive.

A complex technical explanation will suffice.........

Vaya con Dios,
Chuck, CABGx3

Even then, the file should be saved to the hard disk before changing it.

--

JoAnn Paules
MVP Microsoft [Publisher]



Technically, what you are wanting to do is possible.........however,
Floppy
Disk Drives are mechanical devices and therefore inherently subject to
failure which could result in data loss. You would be much better off
using
one of the new pocket "jump" drives, they hold a LOT more data than a
floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3


I have a monthly expense I set up in excel. I have to go from office to
office to different computers so if I add in an expense can or will the
update be saved in the floppy or how can I save the changes?

 

[Dave Peterson]

I agree with almost everything you wrote.

Except for the pushed to the limit portion.

If have a drive with 5 meg available and open a 4 meg file, I may assume that
when I save it (with no changes even), it'll fit. But that's not the way excel
works. This can cause more heartache than it's worth.

I know the most important file I had at work was saved to my home drive on a
network share, copied to a common network share (twice--once for use and once
for common backup).

I'd save a copy on my harddrive and put a copy on two thumb drives (so I could
create a copy on my harddrive at home, too).

I'm not sure I'd want to keep one copy of anything important--including on a
jump drive.

It was a pain making backups and I don't recall any failure of any type, but I
slept better!

ps. lots of people only had trouble once when they save to floppies, too. But
once is more than enough.

Dave "belt and suspenders" Peterson

Uh-huh, uh-huh, and if a hard drive runs out of space, even more "bader"
things will happen, and that's a "for-sure".........but as with anything
else, the JumpDrive must be used within the parameters that exist for it.
NO memory device operates reliably when pushed past it's limit, Hard Drives
included. The JumpDrive is a very effective way of moving files around from
office to office, especially when the offices are not even with the same
company and are not hooked together with a network.......or the network has
so many "MIS monitoring features" on it the computers will hardly run
anyway. Like I said, I have been doing it with 4 different JumpDrives for
a couple of years and no problems........that's not personal opinion, that's
actual FACT.....and the best part is, NOone has access to those files but
ME. As for losing a JumpDrive, or the keys to your car, .......well, thats
not really a legitimate reason for not using JumpDrives or cars either one.
The OP wanted to know about moving files from computer to computer with a
physical device that he could take with him. I've told him of my actual
experience in doing so, and what I think is the best way to do that.

Vaya con Dios,
Chuck, CABGx3

When excel saves a file, it saves it as a new name first. If that works ok, it
either deletes the original or
renames it to something like "backup of book1.xlk".

And then renames that temporary file to the original file name.

If you run out of space on that thumb drive, then bad things can happen.

It's very difficult to remove your harddrive while you're editing the file.

And as large as those jump drives are, there is usually lots more real estate
available on a harddrive.

When excel saves a file, it renames the original file, creates a new file. If
that works ok, it either deletes the original or renames it to something like
"backup of book1.xlk". If you run out of space on that thumb drive, then bad
things can happen.

And a side benefit of saving to a harddrive and copying to the thumb drive is
that you have a backup.

(I bet more thumb drives are just plain lost than desktops or even laptops.)

CLR wrote:

Pray tell "Why"?................I have personally been working off of
various types of Jump Drives for a couple of years with nary a
problem............I can understand it with Floppies, and I suppose anything
is possible, but I cannot even begin to concieve how working off a
mechanical Hard Drive would be considered more reliable than a solid state
Jump Drive.

A complex technical explanation will suffice.........

Vaya con Dios,
Chuck, CABGx3

Even then, the file should be saved to the hard disk before changing it.

--

JoAnn Paules
MVP Microsoft [Publisher]



Technically, what you are wanting to do is possible.........however,
Floppy
Disk Drives are mechanical devices and therefore inherently subject to
failure which could result in data loss. You would be much better off
using
one of the new pocket "jump" drives, they hold a LOT more data than a
floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3


I have a monthly expense I set up in excel. I have to go from office to
office to different computers so if I add in an expense can or will the
update be saved in the floppy or how can I save the changes?

 

[CLR]

LOLOL...........I hear ya Dave. I would never deny the importance of
backups. The way I use my JumpDrive is to change the name/rev of the file
every time I work on it, so I constantly have current "backups". Then when
I'm done and the program works, I remove the old versions. This technique
has saved my bacon on numerous occasions when "things went wrong".......I
could go back in versions until I found one where that feature still worked
and then compare it to the next version to find the trouble. I learned this
the hard way from working on a sleazy network that failed several times a
day. As for "pushed to the limit", I usually keep about 25% of my jump
drives with a directory of music, so I can drown out the local chatter/noise
wherever I'm working.........when I get close to the limit on that drive, I
just dump the music directory and that gives me plenty of space
left.......then when I have time I can archive and clean up the drive. I
agree, with smaller drives it takes a bit of "management", to keep from
maxing them out considering the way Excel saves files, but JumpDrives sure
are convienient for personal security, and for transferring files from one
computer to another. I also keep my personal.xls there as well as various
Add-ins, and even an Image-editing program that I might need when I go from
location to location.......I really wish I could set up the entire Office
Suite on a JumpDrive, but haven't been able to figure out a way to do that
yet.


Vaya con Dios,
Chuck, CABGx3

I agree with almost everything you wrote.

Except for the pushed to the limit portion.

If have a drive with 5 meg available and open a 4 meg file, I may assume that
when I save it (with no changes even), it'll fit. But that's not the way excel
works. This can cause more heartache than it's worth.

I know the most important file I had at work was saved to my home drive on a
network share, copied to a common network share (twice--once for use and once
for common backup).

I'd save a copy on my harddrive and put a copy on two thumb drives (so I could
create a copy on my harddrive at home, too).

I'm not sure I'd want to keep one copy of anything important--including on a
jump drive.

It was a pain making backups and I don't recall any failure of any type, but I
slept better!

ps. lots of people only had trouble once when they save to floppies, too. But
once is more than enough.

Dave "belt and suspenders" Peterson

Uh-huh, uh-huh, and if a hard drive runs out of space, even more "bader"
things will happen, and that's a "for-sure".........but as with anything
else, the JumpDrive must be used within the parameters that exist for it.
NO memory device operates reliably when pushed past it's limit, Hard Drives
included. The JumpDrive is a very effective way of moving files around from
office to office, especially when the offices are not even with the same
company and are not hooked together with a network.......or the network has
so many "MIS monitoring features" on it the computers will hardly run
anyway. Like I said, I have been doing it with 4 different JumpDrives for
a couple of years and no problems........that's not personal opinion, that's
actual FACT.....and the best part is, NOone has access to those files but
ME. As for losing a JumpDrive, or the keys to your car, .......well, thats
not really a legitimate reason for not using JumpDrives or cars either one.
The OP wanted to know about moving files from computer to computer with a
physical device that he could take with him. I've told him of my actual
experience in doing so, and what I think is the best way to do that.

Vaya con Dios,
Chuck, CABGx3

When excel saves a file, it saves it as a new name first. If that

works
ok, it

either deletes the original or
renames it to something like "backup of book1.xlk".

And then renames that temporary file to the original file name.

If you run out of space on that thumb drive, then bad things can happen.

Dave Peterson wrote:

It's very difficult to remove your harddrive while you're editing

the
file.

And as large as those jump drives are, there is usually lots more

real
estate

available on a harddrive.

When excel saves a file, it renames the original file, creates a new file. If
that works ok, it either deletes the original or renames it to

something
like

"backup of book1.xlk". If you run out of space on that thumb drive, then bad
things can happen.

And a side benefit of saving to a harddrive and copying to the thumb drive is
that you have a backup.

(I bet more thumb drives are just plain lost than desktops or even laptops.)

CLR wrote:

Pray tell "Why"?................I have personally been working off of
various types of Jump Drives for a couple of years with nary a
problem............I can understand it with Floppies, and I

suppose
anything

is possible, but I cannot even begin to concieve how working off a
mechanical Hard Drive would be considered more reliable than a

solid
state

Jump Drive.

A complex technical explanation will suffice.........

Vaya con Dios,
Chuck, CABGx3

Even then, the file should be saved to the hard disk before

changing
it.

--

JoAnn Paules
MVP Microsoft [Publisher]



Technically, what you are wanting to do is possible.........however,
Floppy
Disk Drives are mechanical devices and therefore inherently subject to
failure which could result in data loss. You would be much

better
off

using
one of the new pocket "jump" drives, they hold a LOT more data than a
floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3


I have a monthly expense I set up in excel. I have to go from office to
office to different computers so if I add in an expense can

or
will the

update be saved in the floppy or how can I save the changes?

 

[Martie1949]

Thank you all for your comments and advice. I can see what I was trying to
do is a bit risky, so I'll take your advice and go another route. Thanks to
all!!!!!!!!!!!!!Martie

 

[JoAnn Paules [MSFT MVP]]

There's nothing wrong with taking a file on a floppy from location to
location. You just need to make sure that when you edit it, it's been copied
to the target computer, not just on your portable media.

(I'll bet you never expected *this* kind of response to what seemed like
such a simple question, did you?)

 

[Ragdyer]

I really think that the *literal*, verbatim subject line of this thread must
be answered as a *NO*.

You *save* to the HD.
You then *copy* to the floppy (hey!, that rhymes<g>), using Windows
Explorer!

Although for years I've actually calculated and revised WBs *on* a Zip
drive, but I don't consider Zips as a floppy.
And then again, *always* making sure that the Zip capacity was at least
double the size of the WB.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

There's nothing wrong with taking a file on a floppy from location to
location. You just need to make sure that when you edit it, it's been copied
to the target computer, not just on your portable media.

(I'll bet you never expected *this* kind of response to what seemed like
such a simple question, did you?)

--

JoAnn Paules
MVP Microsoft [Publisher]

Thank you all for your comments and advice. I can see what I was trying
to
do is a bit risky, so I'll take your advice and go another route. Thanks
to
all!!!!!!!!!!!!!Martie

 

[CLR]

Since technically it is possible to open an Excel File, from wherever, and
change it, and actually save that changed file to a Floppy Disk...........,
the correct answer to the *literal*, verbatim subject line of this thread is
actually YES!!!

Whether it "should" be done that way or not, is a matter of personal
opinion.

Vaya con Dios,
Chuck, CABGx3

I really think that the *literal*, verbatim subject line of this thread must
be answered as a *NO*.

You *save* to the HD.
You then *copy* to the floppy (hey!, that rhymes<g>), using Windows
Explorer!

Although for years I've actually calculated and revised WBs *on* a Zip
drive, but I don't consider Zips as a floppy.
And then again, *always* making sure that the Zip capacity was at least
double the size of the WB.
--
Regards,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -

There's nothing wrong with taking a file on a floppy from location to
location. You just need to make sure that when you edit it, it's been copied
to the target computer, not just on your portable media.

(I'll bet you never expected *this* kind of response to what seemed like
such a simple question, did you?)

--

JoAnn Paules
MVP Microsoft [Publisher]

Thank you all for your comments and advice. I can see what I was trying
to
do is a bit risky, so I'll take your advice and go another route. Thanks
to
all!!!!!!!!!!!!!Martie

 

[Ragdyer]

Shoulda - Woulda - Coulda - You're right - I stand corrected!<g>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Since technically it is possible to open an Excel File, from wherever, and
change it, and actually save that changed file to a Floppy Disk...........,
the correct answer to the *literal*, verbatim subject line of this thread is
actually YES!!!

Whether it "should" be done that way or not, is a matter of personal
opinion.

Vaya con Dios,
Chuck, CABGx3

I really think that the *literal*, verbatim subject line of this thread must
be answered as a *NO*.

You *save* to the HD.
You then *copy* to the floppy (hey!, that rhymes<g>), using Windows
Explorer!

Although for years I've actually calculated and revised WBs *on* a Zip
drive, but I don't consider Zips as a floppy.
And then again, *always* making sure that the Zip capacity was at least
double the size of the WB.
--
Regards,

RD

!

--------------------------------------------------------------------------
-

There's nothing wrong with taking a file on a floppy from location to
location. You just need to make sure that when you edit it, it's been copied
to the target computer, not just on your portable media.

(I'll bet you never expected *this* kind of response to what seemed like
such a simple question, did you?)

--

JoAnn Paules
MVP Microsoft [Publisher]



Thank you all for your comments and advice. I can see what I was trying
to
do is a bit risky, so I'll take your advice and go another route. Thanks
to
all!!!!!!!!!!!!!Martie

 

[Dave Peterson]

You may want to include a copy of your xlb file, too.

I actually kept my development names as:
nameofworkbook_yyyy_mm_dd.xls

But I'd rename the general copy when I put it in that location.

(I actually kept a giant .zip file of almost all the versions for historical
purposes. You never know when you're gonna have to prove to someone that it
wasn't a program error <vbg>.)

LOLOL...........I hear ya Dave. I would never deny the importance of
backups. The way I use my JumpDrive is to change the name/rev of the file
every time I work on it, so I constantly have current "backups". Then when
I'm done and the program works, I remove the old versions. This technique
has saved my bacon on numerous occasions when "things went wrong".......I
could go back in versions until I found one where that feature still worked
and then compare it to the next version to find the trouble. I learned this
the hard way from working on a sleazy network that failed several times a
day. As for "pushed to the limit", I usually keep about 25% of my jump
drives with a directory of music, so I can drown out the local chatter/noise
wherever I'm working.........when I get close to the limit on that drive, I
just dump the music directory and that gives me plenty of space
left.......then when I have time I can archive and clean up the drive. I
agree, with smaller drives it takes a bit of "management", to keep from
maxing them out considering the way Excel saves files, but JumpDrives sure
are convienient for personal security, and for transferring files from one
computer to another. I also keep my personal.xls there as well as various
Add-ins, and even an Image-editing program that I might need when I go from
location to location.......I really wish I could set up the entire Office
Suite on a JumpDrive, but haven't been able to figure out a way to do that
yet.

Vaya con Dios,
Chuck, CABGx3

I agree with almost everything you wrote.

Except for the pushed to the limit portion.

If have a drive with 5 meg available and open a 4 meg file, I may assume that
when I save it (with no changes even), it'll fit. But that's not the way excel
works. This can cause more heartache than it's worth.

I know the most important file I had at work was saved to my home drive on a
network share, copied to a common network share (twice--once for use and once
for common backup).

I'd save a copy on my harddrive and put a copy on two thumb drives (so I could
create a copy on my harddrive at home, too).

I'm not sure I'd want to keep one copy of anything important--including on a
jump drive.

It was a pain making backups and I don't recall any failure of any type, but I
slept better!

ps. lots of people only had trouble once when they save to floppies, too. But
once is more than enough.

Dave "belt and suspenders" Peterson

Uh-huh, uh-huh, and if a hard drive runs out of space, even more "bader"
things will happen, and that's a "for-sure".........but as with anything
else, the JumpDrive must be used within the parameters that exist for it.
NO memory device operates reliably when pushed past it's limit, Hard Drives
included. The JumpDrive is a very effective way of moving files around from
office to office, especially when the offices are not even with the same
company and are not hooked together with a network.......or the network has
so many "MIS monitoring features" on it the computers will hardly run
anyway. Like I said, I have been doing it with 4 different JumpDrives for
a couple of years and no problems........that's not personal opinion, that's
actual FACT.....and the best part is, NOone has access to those files but
ME. As for losing a JumpDrive, or the keys to your car, .......well, thats
not really a legitimate reason for not using JumpDrives or cars either one.
The OP wanted to know about moving files from computer to computer with a
physical device that he could take with him. I've told him of my actual
experience in doing so, and what I think is the best way to do that.

Vaya con Dios,
Chuck, CABGx3

When excel saves a file, it saves it as a new name first. If that works
ok, it
either deletes the original or
renames it to something like "backup of book1.xlk".

And then renames that temporary file to the original file name.

If you run out of space on that thumb drive, then bad things can happen.

Dave Peterson wrote:

It's very difficult to remove your harddrive while you're editing the
file.

And as large as those jump drives are, there is usually lots more real
estate
available on a harddrive.

When excel saves a file, it renames the original file, creates a new
file. If
that works ok, it either deletes the original or renames it to something
like
"backup of book1.xlk". If you run out of space on that thumb drive,
then bad
things can happen.

And a side benefit of saving to a harddrive and copying to the thumb
drive is
that you have a backup.

(I bet more thumb drives are just plain lost than desktops or even
laptops.)

CLR wrote:

Pray tell "Why"?................I have personally been working off of
various types of Jump Drives for a couple of years with nary a
problem............I can understand it with Floppies, and I suppose
anything
is possible, but I cannot even begin to concieve how working off a
mechanical Hard Drive would be considered more reliable than a solid
state
Jump Drive.

A complex technical explanation will suffice.........

Vaya con Dios,
Chuck, CABGx3

Even then, the file should be saved to the hard disk before changing
it.

--

JoAnn Paules
MVP Microsoft [Publisher]



Technically, what you are wanting to do is
possible.........however,
Floppy
Disk Drives are mechanical devices and therefore inherently
subject to
failure which could result in data loss. You would be much better
off
using
one of the new pocket "jump" drives, they hold a LOT more data
than a
floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3



I have a monthly expense I set up in excel. I have to go from
office to
office to different computers so if I add in an expense can or
will the
update be saved in the floppy or how can I save the changes?

 

[CLR]

Yeah, good idea, thanks Dave........I never messed with the .xlb file
before........thanks for the suggestion.
I also keep all the old versions as I progress along with a programs design.
I use dates, andRev numbers and letters, anything to make it different and
consecutive. I even save when someone comes up and interrupts me. I've had
several occasions where some change the Client had me make caused some
feature to take a dump, and I just go back to where I have two consecutive
saves, one in which the feature worked and the next in which it don't and
then I can usually find out by looking at them what I did
wrong.........saved my bacon a number of times.........

Vaya con Dios,
Chuck CABGx3

You may want to include a copy of your xlb file, too.

I actually kept my development names as:
nameofworkbook_yyyy_mm_dd.xls

But I'd rename the general copy when I put it in that location.

(I actually kept a giant .zip file of almost all the versions for historical
purposes. You never know when you're gonna have to prove to someone that it
wasn't a program error <vbg>.)

LOLOL...........I hear ya Dave. I would never deny the importance of
backups. The way I use my JumpDrive is to change the name/rev of the file
every time I work on it, so I constantly have current "backups". Then when
I'm done and the program works, I remove the old versions. This technique
has saved my bacon on numerous occasions when "things went wrong".......I
could go back in versions until I found one where that feature still worked
and then compare it to the next version to find the trouble. I learned this
the hard way from working on a sleazy network that failed several times a
day. As for "pushed to the limit", I usually keep about 25% of my jump
drives with a directory of music, so I can drown out the local chatter/noise
wherever I'm working.........when I get close to the limit on that drive, I
just dump the music directory and that gives me plenty of space
left.......then when I have time I can archive and clean up the drive. I
agree, with smaller drives it takes a bit of "management", to keep from
maxing them out considering the way Excel saves files, but JumpDrives sure
are convienient for personal security, and for transferring files from one
computer to another. I also keep my personal.xls there as well as various
Add-ins, and even an Image-editing program that I might need when I go from
location to location.......I really wish I could set up the entire Office
Suite on a JumpDrive, but haven't been able to figure out a way to do that
yet.

Vaya con Dios,
Chuck, CABGx3

I agree with almost everything you wrote.

Except for the pushed to the limit portion.

If have a drive with 5 meg available and open a 4 meg file, I may

assume
that

when I save it (with no changes even), it'll fit. But that's not the

way
excel

works. This can cause more heartache than it's worth.

I know the most important file I had at work was saved to my home

drive on
a

network share, copied to a common network share (twice--once for use

and
once

for common backup).

I'd save a copy on my harddrive and put a copy on two thumb drives (so

I
could

create a copy on my harddrive at home, too).

I'm not sure I'd want to keep one copy of anything

important--including on
a

jump drive.

It was a pain making backups and I don't recall any failure of any

type,
but I

slept better!

ps. lots of people only had trouble once when they save to floppies,

too.
But

once is more than enough.

Dave "belt and suspenders" Peterson

CLR wrote:

Uh-huh, uh-huh, and if a hard drive runs out of space, even more "bader"
things will happen, and that's a "for-sure".........but as with anything
else, the JumpDrive must be used within the parameters that exist

for
it.

NO memory device operates reliably when pushed past it's limit, Hard Drives
included. The JumpDrive is a very effective way of moving files

around
from

office to office, especially when the offices are not even with the same
company and are not hooked together with a network.......or the

network
has

so many "MIS monitoring features" on it the computers will hardly run
anyway. Like I said, I have been doing it with 4 different

JumpDrives
for

a couple of years and no problems........that's not personal

opinion,
that's

actual FACT.....and the best part is, NOone has access to those

files
but

ME. As for losing a JumpDrive, or the keys to your car,

........well,
thats

not really a legitimate reason for not using JumpDrives or cars

either
one.

The OP wanted to know about moving files from computer to computer

with
a

physical device that he could take with him. I've told him of my actual
experience in doing so, and what I think is the best way to do that.

Vaya con Dios,
Chuck, CABGx3

When excel saves a file, it saves it as a new name first. If that works
ok, it
either deletes the original or
renames it to something like "backup of book1.xlk".

And then renames that temporary file to the original file name.

If you run out of space on that thumb drive, then bad things can happen.

Dave Peterson wrote:

It's very difficult to remove your harddrive while you're

editing
the

file.

And as large as those jump drives are, there is usually lots

more
real

estate
available on a harddrive.

When excel saves a file, it renames the original file, creates a new
file. If
that works ok, it either deletes the original or renames it to something
like
"backup of book1.xlk". If you run out of space on that thumb drive,
then bad
things can happen.

And a side benefit of saving to a harddrive and copying to the thumb
drive is
that you have a backup.

(I bet more thumb drives are just plain lost than desktops or even
laptops.)

CLR wrote:

Pray tell "Why"?................I have personally been working

off
of

various types of Jump Drives for a couple of years with nary a
problem............I can understand it with Floppies, and I suppose
anything
is possible, but I cannot even begin to concieve how working off a
mechanical Hard Drive would be considered more reliable than a solid
state
Jump Drive.

A complex technical explanation will suffice.........

Vaya con Dios,
Chuck, CABGx3

Even then, the file should be saved to the hard disk before changing
it.

--

JoAnn Paules
MVP Microsoft [Publisher]



Technically, what you are wanting to do is
possible.........however,
Floppy
Disk Drives are mechanical devices and therefore inherently
subject to
failure which could result in data loss. You would be

much
better

off
using
one of the new pocket "jump" drives, they hold a LOT more data
than a
floppy
disk and are considerably more reliable.

Vaya con Dios,
Chuck, CABGx3



I have a monthly expense I set up in excel. I have to go from
office to
office to different computers so if I add in an expense

can
or

will the
update be saved in the floppy or how can I save the changes?

 

[CLR]

No prob RD..........I know how it is with you "younger guys" <VBG>

I also used to work off of ZipDisks too, but switched to JumpDrives because
hardly anyone had ZipDrives where I went......in fact, I've even worked off
of Floppies like the OP asked about, a very very loooooong time ago, in a
land far away.

Vaya con Dios,
Chuck, CABGx3

Shoulda - Woulda - Coulda - You're right - I stand corrected!<g>
--
Regards,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -

Since technically it is possible to open an Excel File, from wherever, and
change it, and actually save that changed file to a Floppy Disk...........,
the correct answer to the *literal*, verbatim subject line of this

thread

is
actually YES!!!

Whether it "should" be done that way or not, is a matter of personal
opinion.

Vaya con Dios,
Chuck, CABGx3




thread
must

--------------------------------------------------------------------------

benefit

!
--------------------------------------------------------------------------

-
There's nothing wrong with taking a file on a floppy from location to
location. You just need to make sure that when you edit it, it's been
copied
to the target computer, not just on your portable media.

(I'll bet you never expected *this* kind of response to what seemed like
such a simple question, did you?)

--

JoAnn Paules
MVP Microsoft [Publisher]



Thank you all for your comments and advice. I can see what I was trying
to
do is a bit risky, so I'll take your advice and go another route. Thanks
to
all!!!!!!!!!!!!!Martie