Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Ron_A
    Guest

    Default Time to save Excel file on Network

    Hi
    I have a number of important files at work - about 1.6 MB in size
    Takes about 4 secs to save at home, 10 secs on my work HDD BUT as much as 28 secs if I save to a network drive at work!
    In each case I am using Excel 2002 in an XP OS

    Is there anything I can do to avoid workarounds such as saving to HDD and then transferring to network at end of day?

    Help please
    Ron

  2. #2
    Oxie
    Guest

    Default Re: Time to save Excel file on Network

    Ron_A

    I am assuming the delay is your copying files to a floppy and then copying them from the floppy to a networked computer. Saving to a floppy and transferring between a floppy and a hard drive always takes longer. Could you not suggest networking your work computer to the other networked computers at work? If you work on the files at home it might be faster to email the files to your networked computer at work.

    Oxie (Lyn)

  3. #3
    Ron_A
    Guest

    Default Re: Time to save Excel file on Network

    Hi
    Thanks But the problem is the time it takes to save the SAME file on the office network.
    The HDD save is fine - or at least reasonable but it takes an AGE for the Exact same file to save on the network

    Any thoughts?

    Ron

  4. #4
    Oxie
    Guest

    Default Re: Time to save Excel file on Network

    So what you are saying, when you create a file and save it on the networked computer it takes a long time to save. Previously I assumed you were copying the files over.

    Have you considered saving on the computer's hard drive, and then at the end of the day copying the files over to the networked drive?

    Oxie (Lyn)

  5. #5
    Ron_A
    Guest

    Default Re: Time to save Excel file on Network

    Yes but that's a hassle - hence my question
    ie Does Excel save DIFFERENTLY on a network?

  6. #6
    Oxie
    Guest

    Default Re: Time to save Excel file on Network

    It doesn't matter what application you are using it will always be faster to save on the computer's hard drive. For example, if I save to my husbands computer's harddrive from my own computer (they are networked) it will definitely be slower than saving directly to my computer's hard drive. Hence it is quicker to create the files locally and copy them over at a later stage (assuming you have quite a few files).

    Oxie (Lyn)

  7. #7
    Mike
    Guest

    Default Re: Time to save Excel file on Network

    > Hence it is quicker to create the files locally and copy them
    > over at a later stage (assuming you have quite a few
    > files).

    Uh, not really. The time it takes to save them across the network is caused by network speed. Therefore saving across the network will take less time that saving to your HDD and then copying across the network. If you were only copying across the network then it possibly could be faster to copy than to save across the network, but the extra time saving to your HDD first probably would negate any time saved in copying. The network speed affects both the saving and the copying across the network - both use the same network protocol, and so travel in the same way. Excel doesn't know that one location is local and the other is on a network, it saves them both the same way.

    So basically saving directly over the network to where you want them will be quicker (especially if you factor in the having to actually go and copy the files later) than saving to HDD and copying later.

    Mike.

  8. #8
    Ron_A
    Guest

    Default Re: Time to save Excel file on Network

    Hi

    Thanks for your reply

    However what I cannot understand is why it actually takes 3 times as long to save the SAME file to the same network drive as it does to save to the HDD.

    The saving to HDD is very fast compared to saving to the network - not the other way around.

    I just cannot understand this - I would have thought the network speed would have been the same - after all I have been working to the file domiciled on the same Network drive

    Thoughts?
    Ron

  9. #9
    Mike
    Guest

    Default Re: Time to save Excel file on Network

    > Thanks for your reply

    You're welcome. Thank you.

    > However what I cannot understand is why it actually
    > takes 3 times as long to save the SAME file to the
    > same network drive as it does to save to the HDD.
    >
    > The saving to HDD is very fast compared to saving to
    > the network - not the other way around.
    >
    > I just cannot understand this - I would have thought
    > the network speed would have been the same - after
    > all I have been working to the file domiciled on the
    > same Network drive
    >
    > Thoughts?

    When your computer writes to the hard drive it writes very quickly. Sending data through a network travels much slower. Theoretically a standard IDE HDD these days transfers data externally (eg from one local drive to another) at a maximum of 100MB/s (megabytes er second). A standard network transfers data at 100Mb/s megabits per second), which works out to be around 12.5MB/s (megabytes per second), or about an 8th of the speed.

    You would also have to factor in any other possible network traffic that might slow your data down (if someone else is writing a large file at the same time across the same network, it will affect your transfer speed).

    Networks run much slower than your computer (and much slower than your hard drive). It also doesn't supply a steady stream of data - data can come in bursts (and can also have many pauses).

    I hope this explains it a little clearer to you.

    Mike.

  10. #10
    Mike
    Guest

    Default Re: Time to save Excel file on Network

    > much slower. Theoretically a standard IDE HDD
    > these days transfers data externally (eg from one
    > local drive to another) at a maximum of 100MB/s
    > (megabytes er second). A standard network
    > transfers data at 100Mb/s megabits per
    > second), which works out to be around 12.5MB/s
    > (megabytes per second), or about an 8th of the
    > speed.

    I forgot to add that the average data transfer speed for a standard HDD these days is around 58MB/s, which is still around 4-5 times faster than a standard 100Mb network maximum transfer speed, which would be where you're getting your difference of about 3 times.

    Mike.

Similar Threads

  1. Excel Save Macro needed
    By Big John in forum PressF1
    Replies: 10
    Last Post: 15-09-2004, 06:17 PM
  2. IE allowing option to save network password
    By Kwakers in forum PressF1
    Replies: 0
    Last Post: 03-09-2002, 06:39 PM
  3. Replies: 14
    Last Post: 29-08-2002, 07:52 PM
  4. Can't save gif file
    By Susan B in forum PressF1
    Replies: 12
    Last Post: 21-08-2002, 10:32 AM
  5. Can't save file as .GIF
    By in forum PressF1
    Replies: 0
    Last Post: 02-07-1999, 03:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •