Get Windows 10 Update from other PC

Downloading Windows update for all your computer units will cost you time and bandwidth.

Since all of your units are downloading same updates, why not download the update on one computer then distribute to other units on the network?

Microsoft have these method embedded on Windows 10 called Windows Update Delivery Optimization.

Windows Update Delivery Optimization lets you get Windows updates and Windows Store apps from sources in addition to Microsoft. This can help you get updates and apps more quickly if you have a limited or unreliable Internet connection. And if you own more than one PC, it can reduce the amount of Internet bandwidth needed to keep all of your PCs up-to-date. Delivery Optimization also sends updates and apps from your PC to other PCs on your local network or PCs on the Internet.

How does Delivery Optimization work?

Delivery Optimization works in two ways.

Download updates and apps from other PCs

In addition to downloading updates and apps from Microsoft, Windows will get updates and apps from other PCs that already have them. You can choose which PCs you get these updates from:

PCs on your local network. When Windows downloads an update or app, it will look for other PCs on your local network that have already downloaded the update or app using Delivery Optimization. Windows then downloads parts of the file from those PCs and parts of the file from Microsoft. Windows doesn’t download the entire file from one place. Instead, the download is broken down into smaller parts. Windows uses the fastest, most reliable download source for each part of the file.

PCs on your local network and PCs on the Internet. Windows uses the same process as when getting updates and apps from PCs on your local network, and also looks for PCs on the Internet that can be used as a source to download parts of updates and apps.

Send updates and apps to other PCs

When Delivery Optimization is turned on, your PC sends parts of apps or updates that you’ve downloaded using Delivery Optimization to other PCs on your local network, or on the Internet, depending on your settings.

Delivery Optimization is turned on by default in Windows 10.

How do I turn Delivery Optimization off?

Here’s how:

1. Go to Start , then Settings > Update & security > Windows Update , and then select Advanced options.
2. On the Advanced options page, select Choose how updates are delivered, and then use the toggle to turn Delivery Optimization off. When turned off, you'll still get updates and apps from Windows Update and from the Windows Store.

If you’d just like to stop downloading updates and apps from PCs on the Internet, select PCs on my local network.

Source: Windows Update Delivery Optimization: FAQ

-Dexter Magalang

Comma separator in excel changed to semicolon (FIX)

If you are used to manually typing formulas in MS Excel, you notice some change after upgrading to Windows 10. The usual comma used to separate arguments was suddenly changed into a semicolon.

It may be a very slight change but may create a great impact if you have been using comma for years, or if you have created automated macros that are designed to use comma as separator.

If you are in the same situation as mine, you might want change the separator back to comma so let’s get started.

1.       Open your Control Panel (right click on Start Menu then choose Control Panel, or type “Control Panel” on the start menu)
2.       Choose Change date, time, or number formats under Clock, Language, and Region.

3.       In the Region dialog box, choose Additional settings... under Formats tab:

4.       In the Customize Format dialog box, under Numbers tab, change the List separator from semicolon to comma or any value/symbol that you wish to use.

5.       Apply all changes.

   Welcome back Comma!

        -Dexter Magalang