Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
#7
|
|||
|
|||
Don.........
Please see my response to JoAnn Vaya con Dios, Chuck, CABGx3 "Don Guillett" wrote in message ... ditto -- Don Guillett SalesAid Software "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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel keeps checking for a floppy... | Excel Discussion (Misc queries) | |||
How do you turn off automatic "save a copy" in Excel | Excel Discussion (Misc queries) | |||
Excel prompts me to save a copy or overwrite file. | Excel Worksheet Functions | |||
Excel 2002 crashing during "Save As" action. | Excel Discussion (Misc queries) |