Share Excel workbook to edit simultaneously

The workbook however need to be in a network share. it must have a write privilege to all your team members. 

 Here follow these steps.

1. Open your workbook.
2. Navigate to Review on the toolbar
3. Click on the Share Workbook icon
4. Place a check on the check box that says Allow more than one user at the same time.
5. Click on OK
6. Now, save your workbook on a network share

Installing an SSL Certificate in Microsoft Exchange Server 2010

1. Create a new certificate in exchange.

         Enter certificate name  -> Enable Wildcard certificate  -> Organization and Location

2. Open the certificate in note pad and copy the key. (CSR)

3. Login to godaddy and paste the key for new certificate.

4. Checked email, validate and download certificate.

5. Import the certificate into the one created before.

6. Assign services to certificate.

Exchange server 2010 requires a Multiple Domain (UCC) Certificate to run all services securely.

To Install an SSL Certificate in Microsoft Exchange 2010

1. To install the intermediate certificate, click Start, and then click Run..
2. Type mmc, and then click OK. The Microsoft Management Console (Console1) window opens.
3. In the Console1 window, click File, and then select Add/Remove Snap-in.
4. In the Add or Remove Snap-ins window, select Certificates, and then click Add.
5. In the Computer Account window, select Computer Account, and then click Next.
6. In the Select Computer window, select Local Computer, and then click Finish.
7. In the Add or Remove Snap-ins window, click OK.
8. In the Console1 window, click + to expand the Certificates (Local Computer) folder on the left.
9. Right-click Intermediate Certification Authorities, mouse over All Tasks, and then click Import.
10. In the Certificate Import Wizard window, click Next.
11. Click Browse to find the intermediate certificate file.
12. In the Open window, change the file extension filter to PKCS #7 Certificates (*.spc;*.p7b), select the *_iis_intermediates.p7bfile, and then click Open.
13. In the Certificate Import Wizard window, click Next.
14. Select Place all certificates in the following store, and then click Browse.
15. In the Select Certificate Store window, select Intermediate Certification Authorities, and then click OK.
16. In the Certificate Import Wizard window, click Next.
17. Click Finish.
18. Click OK.
19. Close the Console1 window, and then click No to remove the console settings.
20. To install the primary certificate, click Start, click All Programs, Microsoft Exchange Server 2010, and then click Exchange Management Console.
21. In the Exchange Management Console, click Microsoft Exchange On-Premises, and then click Manage Databases.
22. Click Server Configuration.
23. In Exchange Certificates, select your certificate, and then, from the Actions panel on the right, click Complete Pending Request.
24. In the Complete Pending Request window, click Browse to locate the certificate file.
25. In the Open window, select All Files(*.*) as your file name extension, select your certificate (it might be saved as a .txt, .cer, or .crt), and then click Open.
26. In the Complete Pending Request window, click Complete.
    
    NOTE: If you receive the error, "The source data is corrupted or not properly Base64 encoded," check the Self Signed field. If it is True, refresh console by pressing F5 on your keyboard. If it still displays True, create a new CSR and then re-key your certificate.
27. Click Finish.
28. In the Exchange Management Console, select your certificate in Exchange Certificates.
29. From the Actions menu, click Assign Services to Certificate.
30. In the Assign Services to Certificate window, select the servers you want to assign services to, and then click Next.
31. Select services you want to assign to the certificate, and then click Next.
32. Click Assign.
33. Click Finish.

https://support.godaddy.com/help/article/5863/installing-an-ssl-certificate-in-microsoft-exchange-server-2010?countrysite=au

Watch Guard RDP Rule

Login to watched guard. Open policy manager

Save and exit

How do I move System Reserve partition to system partiton C:

If C is a primary partition - mark it active. (Disk management )

Mark sys reserved inactive ( elevated command :

diskpart

sel vol G: ( use E if E is sys resd drive letter )

inact

exi 

bcdboot c:\windows /s c:

Reboot.

BackupAssist - Volume Shadow Copy Error 0x8004230f - unexpected provider error

Solution 1

HDD sector size must be 512K

Not 4096K

Find the suitable HDD

Solution 2

Upgrade the BackupAssist software

The error basically means that the system doesn't have enough of a buffer to hold all write operations occurring during a backup.
You need to increase the area allowed to VSS to buffer such write operations.

Please follow the steps below to check and if need to, adjust the shadow copy space allocated for a particular volume.

To check the current limit set: vssadmin list shadowstorage

To change the limit: vssadmin Resize ShadowStorage /For=X: /On=X: /Maxsize=XX%

or

vssadmin Resize ShadowStorage /For=X: /On=X: /Maxsize=XXGB

This will resize the limit to XX size for the X: drive.

Windows 7 Does not assign a Drive Letter automatically

Open command prompt

type in

diskpart

automount enable

Import a WAB file into Outlook Contacts

Step 1: Import to Windows Contacts

Double click on the .wab file and click Import. (This step is so easy and so fast you might not realize what happened.)

If you don't have the .wab file and still have access to the old computer, look for it at C:\Documents and Settings\username\Application Data\Microsoft\Address Book. It may be named username.wab. Copy it to the new computer.

Step 2: Using Outlook 2010 and older

If you use Outlook 2010 or older, you can import the Windows Contacts.

1. Open the Import/Export wizard. In Outlook 2010/2013, it's at File, Open, Import; in older versions, it's on the File menu.
2. Choose Import Internet Mail and Addresses. Click Next.
3. Choose Outlook Express.

4. Deselect Import Mail.
5. Choose whether to allow duplicates to be created.
6. Click Finish.

Depending on how many contacts you have, it can take from a few seconds to a few minutes to import the contacts.

Step 2: Using Outlook 2013

Outlook 2013 has limited import options. Your choices are Comma Separated Values (CSV) or vCards so you'll need to export the contacts from Windows Contacts in either CSV or as vCards. Because it's annoying to import a large number of vcards unless you use a macro, I recommend exporting in CSV format.

1. Open Windows contacts. In Windows 7, type Contacts in the Start search field; in Windows 8, type Contacts on the Start screen. Press Enter to open Contacts.
   Click Export. If you don't see Export to the far right of Organize, expand the bar or maximize the window.

2. Choose CSV (Comma Separated Values) from the Export Windows Contacts dialog.
3. Click Export.

4. Click Browse and type in a name for your CSV file.
5. Click Save, then click Next.
6. Select the fields to include in the Export. I recommend select all fields. (You need to click in each box.)
7. Click Finish the Export.
8. Close the Export dialog.

Now switch to Outlook 2013.

1. Open File, Open & Export.
2. Select Import/Export to open the Import/Export wizard .
3. Choose Import from another program or file. Click Next.

4. Choose Comma Separated Values.
5. Browse to the file you exported earlier
6. Choose whether to allow duplicates to be created.
7. Select your Contacts folder.
8. Click Finish.