What are the Ways To Manage Excel Workbook Connections?

Some of the computer users, don’t know how to manage the Excel Workbook connection. So, in this blog you will read the ways to manage Excel Workbook connection. To know more about Excel, go to the site of Microsoft Office via www.office.com/setup.

Method To Manage Excel Workbook Connections: Office.com/setup

1: Using Workbook Connections Dialog Box:

It helps to manage the single or multiple connections with the external data sources of your workbook. Along with this, it helps to edit, refresh, create and also delete connections which are there in workbook. It also helps to show the location of each connection which is used in the current Excel workbook. With this, you can diagnose the error message related to external data connections. It also helps to redirect connection to different data or to the different server. Or you can also replace the connection file with the existing connection. With this, you can make & share connection files.

To Manage Excel Workbook Connection By Using Workbook Connections Dialog Box:

  1. Identify a Connection: You can identify all the connections in the Excel workbook as it appears automatically with the following information like Name of the connection with connection Properties, description about the connection, and it also gives the information when was the connection was last refreshed. If the refresh option is blank, this means the connection has not refreshed yet.
  2. Add a Connection: You should click on the Add option just to get the dialog box of Existing Connections.
  3. Display Connection Information: First, you have to select a connection from the opened Existing Connections dialog box. Then, you should click on the Properties option and then the Connection Properties dialog box will open.
  4. Refresh The External Data: First, you have to click on the arrow option which is next to the Refresh option. After this, you should perform anyone of the following:

    If in case, you wish to refresh any specific connections, then you should make selections of those connections. After this, click on the Refresh option.

    If you want to refresh all the connections of your workbook, then you should clear off all the connections. Then, hit on the Refresh All option.

    For getting, the status information about refresh operation then you should select the connections for which you require to extract information. Then, press Refresh Status option.

    To stop the current running refresh operation, hit on the Cancel Refresh option.
  5. Remove One Or More Connections: You should select the connections which you wants to remove from your workbook. Then, hit on the Remove option.

2: By Using Refresh External Data Connection Option:

If you want to Use Refresh External Data Connection Option, first you should click on any cell of your Excel table which has the connection. After this, you should perform any of the following operation:

Automatically refresh data when excel workbook is opened

Automatically refresh data at regular interval

To Automatically Refresh Data When Excel Workbook Is Opened, you should click on the cell which is in the external data range. Then on the Data tab, you should go to the Queries & Connections. After this, click on the arrow key in the Refresh All option, and then click on the Connection Properties. Here, from the opened dialog box of Connection Properties, you should click on the Usage tab, in Refresh control. Then, just select the check box “Refresh data when opening the file”. To save your workbook, you should select the check box “Remove data from the external data range before saving the workbook”.

To Automatically refresh data at regular interval, you should click on the cell which is there in the external data range. Then, on the Data tab, you should go to the Queries & Connections. After this, click on the arrow key in the Refresh All option, and then click on the Connection Properties. Now, in the opened Connection Properties dialog box, you should click on the Usage tab option. At last, you should select the check box Refresh every. After this, you should set the minute interval which will automatically refresh your data.

3: By Creating Office Data Connection (ODC) File:

You can use the Data Connection Wizard or Connection Properties dialog box to create an Office Data Connection (ODC) file (.odc). For this, you should make new connection with data source. Like Connect to SQL Server Analysis Services Database, Import or export text files and also you can move data from Excel to Access. Here, you can also make use of the existing connection. After this, you have to save the connection detail in the connection file. You should click on the Export Connection File option which is on the Definition tab of Connection Properties dialog box. It will open the File Save dialog box, you should save your current connection information in the ODC file.

For details information about Excel application, visit to the official site of MS Office via www.office.com/setup.

How You Can Encrypt Emails in Outlook?

Basically, Email encryption is the process of hiding the content of your email messages so that unwanted email contacts cannot be able to read it. It will be good, if you encrypt all emails as they contain sensitive information. In this blog, you will read how you can encrypt email in Outlook. For details, just go to the official site of MS Office via Office.com/setup.

Types of Email Encryption in Outlook:

Basically, there are two types of email encryption in Outlook. One is PGP/ MIME and the other is S/ MIME. Both, Receiver and Sender must have the same type of encryption so that the recipient can decrypt an email which the sender encrypts.

In PGP/ MIME email encryption,  the recipient should have both public and private encryption keys, and the sender must have the public key. It uses a decentralized and also the distributed model of trust. In this, the Web-based email clients are easy to use. It needed a third-party tool which is not supported by the email clients.

Other type of email encryption is S/ MIME. In this, the recipients must have received one signed email from the sender. This type of encryption is easy to maintain. It selects the encryption algorithm and also the key size from a centralized authority. It is difficult to configure, if you use internet-based email providers.

How you can Encrypt Email In Outlook 2016? www.office.com/setup

You should open your operating system and then just click on the ‘Start’ icon. After this, you should go to File option and then drop-down the ‘Options’ tab. Then, expands its options and just click on ‘Trust Center’. Now, you should select the ‘Trust Center Settings’ option. At this point, you should find ‘Email Security’ option and then press on ‘Get a Digital ID’ tab. At last, you should select ‘The Type of Certification Authority’ which you want to receive.

Now, you will get the ‘Digital ID’ in the form of an email message. After this, you should download the certificate and follow the method how to encrypt email in Outlook.

First, you should open Outlook 2016 and then go to the ‘Tools’. After this, from the drop-down, you should click on the ‘Options’ tab. Now, you have to select the tab of ‘Security’ and then open it. Then, you have to enter your ‘Name of your choice’ if you have to fill the ‘Security Settings Name’. After this, you should select the ‘S/MIME’ option as the ‘Types of Email Encryption’ which is next to the ‘Secure Message Format box’. Now, you have to check the box, ‘The Default Security Setting’. At this point, you should click on the ‘Certificates and Algorithms’ and then from the drop-down menu, you should select the ‘Signing Certificate’ tab. Here, you should click on the ‘Choose’ tab and then select ‘Secure Email Certificate’ option from the ‘Select Certificate box’. After this, select ‘Send these Certificates with Signed Messages’ option and then click on ‘Ok’ button. At the end, you have to click on the ‘Save the Settings’ option just to complete the process and then back to your Outlook home page. Finally, you have created a Digital Signature in your email message. This will not appear by default, if you want to attach them just follow the procedure.

Also Read – How to Fix If Window Defender Closes Games on Window 10?

For this, on the homepage of ‘Outlook’, you should go to the ‘New Message’ and then click on it. After this, you should click on the ‘Tools’ and then expand its options to select ‘Customize’. Then, you have to press the ‘Commands’ tab and then drop-down its ‘Categories list’. And you should select ‘Standard’ option and then click on the ‘Digitally Sign Message’. Here, press the listing to your toolbar, and just add your digital signature. At the end, you have to click on the ‘Encrypt Message Contents and Attachments’ and then drag it to the toolbar.

The above method helps to encrypt emails in Outlook. For more information about the application of Outlook, visit to the site via Office.com/setup.

How you can Use Microsoft Office for Free?

Microsoft Office is the software which is continuously introducing its latest version of Office Suite with the increased time for the facility of the user. You can install this software through office.com/setup. This software is used in homes as well as for business purpose. Through this software you can do formatting, editing, creating text document, making presentation etc. You can also schedule your meetings and conferences with MS Outlook. No other software has the ability which has so may IT applications. Each application of MS Office has different functions and the user use these applications according to its purpose. If somebody wanted to use MS Office for free then there are 4 ways through which you can use MS Office for free.

Ways for Using MS Office for Free:

  1. Use Office 365 on your Phone: Microsoft allows its users to download the basic mobile applications for free. You can store your data in cloud storage. You can also access, and share files with anyone through cloud storage. It will consume less memory of your device. But mobile apps have limited features to Office 365 users. You can’t edit text if the device screen is larger than 10.1 inches.
  2. Use Office 365 on Web: If you have a MS account and you are connected to the internet or Wi-Fi, you can use the MS Office Suite for free. You just have to sign in to office.com with your MS account and you can use any Microsoft Office Suite application according to your need. But the disadvantage here is that you cannot use the Office application without the internet. Your data will be stored in the cloud. This is the best way to use the Microsoft Office Suite as it is free, and it also save memory of your device. And also you can access your documents from any device.
  3. Go Back To School: You can enjoy the version of Office 365 for free if you are studying at an educational organization. Microsoft has launched Office 365 Education, this allows students with school email ID to download all applications of MS Office Suite for free during their school time. You can share documents so that you can work from anywhere. Students can take advantage of the Microsoft Teams or Skype applications for organizing meetings.
  4. Free Trial of Office 365: If you wanted to work for a single project, then the free 30-day trial of MS Office Suite is best for you. For this, you have to go to this page and sign up. Through this you can download Office 365 on multiple PCs, Macs, and mobile devices. You can work online as well as offline, and you get cloud storage facility also. The applications which you will get are Word, Excel, PowerPoint, and Outlook. You can only use this trial version for once.

For more information, you can visit to the official website of MS Office through www.office.com/setup.