How to Troubleshoot If Excel Smart View is Not Showing?

Excel is the widely used application of Microsoft Office and can install via office.com/myaccount. Sometimes users face the issues Excel Smart View is not showing. Hence in this blog, you will read the solution to fix Excel Smart View is not Showing.

Method to Fix If Excel Smart View is Not Showing:

1: Download & Install Smart View:

Before you begin the downloading process, you should have the admin access on your device in which you want to download the Smart View. You should close all the opened Microsoft applications. If in case, any Smart View of the older version is there on your device then you should immediately uninstall it.

Download Smart View in Excel:

To download Smart View, you have to double-tap on the application file of “SmartView”.Now from the opened dialog box, you have to click on the “Extract all”. After this, you should hit the “Extract” button in the next opened dialog box. Herein the extracted folder, you should right-click on the “SmartView” application file and then hit on “Run as administrator” option. Then in the opened box of “oracle Smart View for office installation”, you have to tap on the “OK” button to install the Smart View process.

Keep in mind that the Installation process takes some time according to the internet connection speed. If you see any black boxes which pop-up on your screen then do not touch anything because this will interrupt the installation process. When the download process complete, then you will see a small dialog box related to the confirmation of the downloading process displays on your screen. At last, open your Excel application and check if the Smart View displays in Excel ribbon or not. For more detail, visit Www.office.com/setup.

2. Load Smart View Add-in:

To enable the Smart View add-in, you should open the system registry editor. To do this, click on the Start menu and then in the search box type “regedit”. After this, you should click on this:  HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Hyperion.CommonAddin.

You should set loading behavior to 3. If in case, this LoadBehavior is set on anything else than “3” then first you should close the Excel application and then cross-check over the Windows Task Manager in order to confirm that no “excel.exe” process is executing. Then, you should open the registry editor again and then double-click on the registry key for editing it. After this, you should change the Load Behavior to “3” and then close registry editor. At last, open your Excel application and you will view the Smart View add-in gets loaded automatically during the Excel startup.

3. Enable Smart View Add ins:

First, open your Excel application and then tap on the Options button from the bottom section of the left sidebar. After this from the Excel options window, you should choose the add-ins. Now in the top section, you will see the option ‘Active Application Add-ins’. There it has listed with SmartView twice. Just scroll down at the bottom screen and then check the section ‘Disabled Application Add-ins’. If in case, the Smart View for Office appears to you disabled then you should change the option to enable and hit on OK.

4. Re-Install Smart View:

You should visit to your system’s Start. Then, you should click on the settings and then click on Apps & features. After this, you should make a selection of the Smart View program and then click on the Uninstall. When you uninstall it, just Restart your system. At last, again reinstall the Smart View application in Excel.

For more information about Excel, go to office.com/setup.

How You Can Open Encrypted Files in Window 10?

The user has to face trouble, if they have the encrypted file but they don’t know the password to open it. In this blog, you will read the method to open the encrypted file in Window 10. For more details, visit Office.com/setup.

Method to Open Encrypted Files in Window 10:

1. Use Dedicated Program: There are many programs which are used to encrypt files so that you know that they are password-protected. As you all know that the encrypted files can be opened, but sometimes you need to use the same programs to encrypt them. WinZip is a program which is use to encrypt file. And to open an encrypted WinZip file, you require the password. With the WinZip, you can’t recover the lost zip file passwords. For help, Visit Www.office.com/setup.

2. Use Certificate Manager: First, log in to the user account which encrypted the file you wish to access. Then in the search box, you need to type certmgr.msc and then press Enter key in order to open the Certificate Manager. After this, you should open the Personal category which is in the left side. Next, you need to tap on Certificates. Now under Issued To, you have to select the certificate which corresponds with your account name. Here, you need to open Action menu. At this point, you should go to All Tasks and then select Export and here, follow the instructions in the Export wizard. Then, you need to tap on Yes, export the private key and Personal Information Exchange if asked. After this, you have to type a password for the certificate and then tap on Finish option. Now, you should Transfer the certificate file to the computer which you want to open. Then, open the Certificate Manager on that computer and then select Personal. At this point, open Action menu and go to All Tasks and then select Import. Here, follow the instruction in the Import wizard. Just select the certificate file which you moved, and then type the password and then check the Mark this key as exportable box. At this point, select Personal as the location just for placing the certificate and then tap on Finish. At last, you need to double click the encrypted file to open it and the certificate which you transferred will give you access to the file.

3. Take ownership of the file or folder: You have to open File Explorer and then find the file or folder which you want to take ownership of. Then, you have to right-click the file or folder, and then tap on Properties. After this, you should tap on the Security. Now, you need to tap on Advanced and then tap on the Owner. At this point, you need to tap on Change and then just do one of the following:  You should change the owner to a user or group which is not listed or you should change the owner to a user or group which is listed.

The above method helps to open the encrypted file in Window 10. If the customer need help, then visit to Microsoft via office.com/setup.

Amazing Tips For Creating A Stylish Excel Spreadsheet

Many users use Excel application as it is easy to use but if the user has to create a stylish Excel spreadsheet then this is a very tough job. You can setup MS Office software in your device via www.office.com/setup. If you create a beautiful spreadsheet then it will be pleasing to your eyes and also makes bugs more clear. Hence, in this blog you will read how to create a stylish and beautiful spreadsheet.

How To Create a Stylish Excel Spreadsheet? Office.com/setup

1. Check out a Template:

If you don’t know where to start, then you should check out the templates which are available on the web. Just look at them.

2. Select the Right Font:

You should always choose a clear and a readable font like Arial or Calibri for creating an attractive and professional like spreadsheet.

3. Limit Use of Different Fonts:

Always keep in mind that two different types of font styles will help to differentiate between headers and text. But if there are many fonts then it will not look like professional.

4. Center your Title:

To create a professional spreadsheet, you should center your title for your spreadsheet. For this, you should use the “Merge Cells” or “Center Across Selection” options.

5. Start in b2:

To create some space in your document, you should leave row 1 and column A blank so that spreadsheet look neat and tidy and also easy to understand.

6. Bold your Headers:

As Headers is different from the main text, so you should bold them and this will make your spreadsheet easier to read.

7. Vary your Font Sizes:

For making spreadsheet easy to read, you should use a larger font size for headings and sub-headings. Proper font size will make your spreadsheet clear and easy to understand.

8. Align Text:

You should format your cells and also select the options which allow you to align your text according to your needs. Like you should text aligns to the left by default, and numbers align to the right and give them headings according to the table contents.

9. Create Space:

You can adjust the height and width of cells just to make your spreadsheet neat and tidy.

10. Leave Some Cells Empty:

If in case, your spreadsheet looks complex, then you should leave a row or column empty to maintain the breaks in the data. This will improve readability.

11. Use Color Sparingly:

You can use colors in Excel just to highlight the key rows or columns, to make your spreadsheet more attractive and easy to read. But remember, don’t overdo it.

12. Keep Dark Text on a Light Background:

If you are choosing colors for your spreadsheet, then you should select dark text on a light background, as this will make your spreadsheet easier to read and prints better.

 13. Add an Image:

In your spreadsheet, you can add a simple image like your company logo as this will make your spreadsheet professional and attractive.

14. Name your Worksheets:

You should name your worksheet as this will help to keep everything well-organized and in a professional way.

The above are some of the tips which help to create a stylish spreadsheet. For more help or support, you can contact the expert of MS Office through Office.com/setup.

If Microsoft Team Calls Not Ringing! How to Fix it?

Microsoft Team is a collaboration tool, through which you can communicate efficiently. But sometimes user find problem like Microsoft Team Calls not ringing. Hence, in this blog you will learn about the solution of this problem. For help, the user can contact to the customer care of Microsoft via Office.com/setup.

Method To Fix Microsoft Team Calls Not Ringing: Office.com/setup

1. Check Microsoft Teams Call Settings:

First, you should click on your profile picture which is located at the top of Teams. Then, you should click on Settings and then select Calls. After this, you should ensure the setting for Always ring on this device even when active on desktop is checked.

2. Verify Quiet Hours Settings:

For this, you should enter into your Teams client. After this, you should go to Settings option and then click on Notifications and then select Quiet Hours. At this point, you can set start and stop times for particular day or all days of the week. You can remove any of the previously made changes just by clicking on the switch which is next to Daily quiet hours.

Normally, workers have their PC and mobile with MS Teams app. But if both of them rings, if a call come then this will create a problem. And also if you are out of office, and you don’t want any interruption by a Teams call then in the Teams mobile client you can set quiet hours for yourself, so that it doesn’t ring your mobile phone.

3. Remove Microsoft Teams Blocked Numbers:

For this, you should click on your profile picture. Then, you have to go to Settings and select Calls. After this, you should select Manage blocked numbers under Block calls. At this point, you can get access to all any numbers which you’ve blocked or you can remove them from the list.

If in case, you want to view and manage the numbers which you’ve blocked then you should follow the above method. Through this, Microsoft Teams calls work again.

4. Check Microsoft Teams is Up-to-Date:

You should start just by clicking on your profile picture which is located at the top of the app. Then, you should select Check for updates. Updates will help to maintain the health of the app.

5. Ensure you are Connected to Internet:

You should click on your profile picture which is located at the top of Teams. Then, you should click on Settings option. After this, you should tap on Update and Security option. Now, you should select Troubleshoot from the left-side menu. Here, you should scroll down and then click on the Internet Connections option. At this point, you should click on Run the troubleshooter. Next, you have to follow the on-screen instructions just to complete the process. At last, you should Restart Teams and then just check if the issue still persists or not.

The above method will help you to fix Microsoft Team Calls not Ringing Issue. If the user want any help or support, then they can call the customer care of MS Office via Office.com/setup.

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.