USB 3 v One Drive

[Mel Smith]

I have a fairly large Workbook with some 250+ worksheets. A lot of the data is entered on one sheet, which links through to several others and so on. The workbook is stored/saved to my OneDrive account but I’m finding that data entry is taking quite a long time. For example when I enter the data (which filters through to other sheets) there is quite an appreciable time lag. Could this be because the file is located in OneDrive and would it speed things up if the entire workbook was on removable media through USB 3?

Any thoughts or suggestions will be appreciated.

Mel

 

[mole999]

The USB would be a good way, as long as your system is also USB 3 , they normally have a blue tang to denote which supports 3. The time lag I would guess is down to network speed, in the UK upload speed is often less than a quarter of what the download speed is

As a general rule, the best upload speed in the UK is around 20Mbps, which is exclusive to the top-end fibre broadband packages. Entry-level fibre broadband packages tend to have upload speeds of up to 10Mbps.

USB 3.2, released in September 2017, replaces the USB 3.1 standard. It preserves existing USB 3.1 SuperSpeed and SuperSpeed+ data modes and introduces two new SuperSpeed+ transfer modes over the USB-C connector using two-lane operation, with data rates of 10 and 20 Gbit/s (1250 and 2500 MB/s).

If you need occassional access to the online data while out then, upload weekly

 

[Mel Smith]

Many thanks. Yes, my laptop does support USB 3.

Once again, thank you.

Mel