Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Martie1949
 
Posts: n/a
Default Can I save changes to excel on a floppy?

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?

  #2   Report Post  
JoAnn Paules [MSFT MVP]
 
Posts: n/a
Default

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. ;-)
--

JoAnn Paules
MVP Microsoft [Publisher]



"Martie1949" wrote in message
lkaboutsoftware.com...
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?



  #3   Report Post  
CLR
 
Posts: n/a
Default

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


"Martie1949" wrote in message
lkaboutsoftware.com...
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?



  #4   Report Post  
JoAnn Paules [MSFT MVP]
 
Posts: n/a
Default

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

--

JoAnn Paules
MVP Microsoft [Publisher]



"CLR" wrote in message
...
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


"Martie1949" wrote in message
lkaboutsoftware.com...
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?





  #6   Report Post  
CLR
 
Posts: n/a
Default

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




"JoAnn Paules [MSFT MVP]" wrote in message
...
Even then, the file should be saved to the hard disk before changing it.

--

JoAnn Paules
MVP Microsoft [Publisher]



"CLR" wrote in message
...
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


"Martie1949" wrote in message
lkaboutsoftware.com...
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?







  #8   Report Post  
Dave Peterson
 
Posts: n/a
Default

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

"JoAnn Paules [MSFT MVP]" wrote in message
...
Even then, the file should be saved to the hard disk before changing it.

--

JoAnn Paules
MVP Microsoft [Publisher]



"CLR" wrote in message
...
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


"Martie1949" wrote in message
lkaboutsoftware.com...
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
  #9   Report Post  
Dave Peterson
 
Posts: n/a
Default

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

"JoAnn Paules [MSFT MVP]" wrote in message
...
Even then, the file should be saved to the hard disk before changing it.

--

JoAnn Paules
MVP Microsoft [Publisher]



"CLR" wrote in message
...
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


"Martie1949" wrote in message
lkaboutsoftware.com...
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


--

Dave Peterson
  #10   Report Post  
CLR
 
Posts: n/a
Default

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




"Dave Peterson" wrote in message
...
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

"JoAnn Paules [MSFT MVP]" wrote in message
...
Even then, the file should be saved to the hard disk before changing

it.

--

JoAnn Paules
MVP Microsoft [Publisher]



"CLR" wrote in message
...
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


"Martie1949" wrote in message

lkaboutsoftware.com...
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


--

Dave Peterson





  #11   Report Post  
Dave Peterson
 
Posts: n/a
Default

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

"Dave Peterson" wrote in message
...
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

"JoAnn Paules [MSFT MVP]" wrote in message
...
Even then, the file should be saved to the hard disk before changing

it.

--

JoAnn Paules
MVP Microsoft [Publisher]



"CLR" wrote in message
...
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


"Martie1949" wrote in message

lkaboutsoftware.com...
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


--

Dave Peterson


--

Dave Peterson
  #12   Report Post  
CLR
 
Posts: n/a
Default

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




"Dave Peterson" wrote in message
...
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

"Dave Peterson" wrote in message
...
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

"JoAnn Paules [MSFT MVP]" wrote in message
...
Even then, the file should be saved to the hard disk before

changing
it.

--

JoAnn Paules
MVP Microsoft [Publisher]



"CLR" wrote in message
...
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


"Martie1949" wrote in message

lkaboutsoftware.com...
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

--

Dave Peterson


--

Dave Peterson



  #13   Report Post  
Martie1949
 
Posts: n/a
Default

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

  #14   Report Post  
JoAnn Paules [MSFT MVP]
 
Posts: n/a
Default

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]



"Martie1949" wrote in message
lkaboutsoftware.com...
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



  #15   Report Post  
Ragdyer
 
Posts: n/a
Default

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 !
---------------------------------------------------------------------------
"JoAnn Paules [MSFT MVP]" wrote in message
...
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]



"Martie1949" wrote in message
lkaboutsoftware.com...
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






  #16   Report Post  
CLR
 
Posts: n/a
Default

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




"Ragdyer" wrote in message
...
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 !
--------------------------------------------------------------------------

-
"JoAnn Paules [MSFT MVP]" wrote in message
...
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]



"Martie1949" wrote in message
lkaboutsoftware.com...
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






  #17   Report Post  
Ragdyer
 
Posts: n/a
Default

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"CLR" wrote in message
...
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




"Ragdyer" wrote in message
...
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

!

--------------------------------------------------------------------------
-
"JoAnn Paules [MSFT MVP]" wrote in message
...
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]



"Martie1949" wrote in message

lkaboutsoftware.com...
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







  #18   Report Post  
Dave Peterson
 
Posts: n/a
Default

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



CLR wrote:

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

"Dave Peterson" wrote in message
...
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

"Dave Peterson" wrote in message
...
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

"JoAnn Paules [MSFT MVP]" wrote in message
...
Even then, the file should be saved to the hard disk before

changing
it.

--

JoAnn Paules
MVP Microsoft [Publisher]



"CLR" wrote in message
...
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


"Martie1949" wrote in message

lkaboutsoftware.com...
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

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #19   Report Post  
CLR
 
Posts: n/a
Default

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



"Dave Peterson" wrote in message
...
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.)



CLR wrote:

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

"Dave Peterson" wrote in message
...
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

"Dave Peterson" wrote in message
...
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

"JoAnn Paules [MSFT MVP]" wrote in

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

changing
it.

--

JoAnn Paules
MVP Microsoft [Publisher]



"CLR" wrote in message
...
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


"Martie1949" wrote in message


lkaboutsoftware.com...
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

--

Dave Peterson

--

Dave Peterson


--

Dave Peterson



  #20   Report Post  
CLR
 
Posts: n/a
Default

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



"Ragdyer" wrote in message
...
Shoulda - Woulda - Coulda - You're right - I stand corrected!<g
--
Regards,

RD

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

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

-
"CLR" wrote in message
...
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




"Ragdyer" wrote in message
...
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
!


--------------------------------------------------------------------------
-
"JoAnn Paules [MSFT MVP]" wrote in message
...
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]



"Martie1949" wrote in message

lkaboutsoftware.com...
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









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
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel keeps checking for a floppy... Gregory A. Wandless Excel Discussion (Misc queries) 12 June 7th 05 05:55 PM
How do you turn off automatic "save a copy" in Excel Cecilia Quinn Dean Excel Discussion (Misc queries) 2 May 22nd 05 06:43 PM
Excel prompts me to save a copy or overwrite file. Vinny Excel Worksheet Functions 0 May 20th 05 03:05 PM
Excel 2002 crashing during "Save As" action. Andy T Excel Discussion (Misc queries) 1 January 4th 05 11:34 PM


All times are GMT +1. The time now is 11:28 PM.

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

About Us

"It's about Microsoft Excel"