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.

Visit Also – How To Resolve Common Microsoft Word Errors?

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

How to Troubleshoot MS Word Not Responding Issue?

Microsoft Word is the popular Word processor of MS Office software. But if this software fails or stuck in between your work due to unwanted bugs or corrupted files, then this is a serious problem. Hence, in this blog you will read the solution of the MS Word Not Responding Issue. For help or support, just visit to the site of MS Office through www.office.com/setup.  

Causes of MS Office Not Responding Issue: office.com/setup

The causes of the MS Office Not Responding Issue are unwanted bugs and viruses in your PC, may be user’s system cause corruption in MS Word files, improper functioning of the software and also if third-party add-ins are creating problem in the normal working of  MS Word files.

Solution To Troubleshoot MS Word Not Responding Issue: office.com/setup

1. Disable all Add-inns:

To fix this issue, you should remove all the corrupted files and Add inns from your computer system for the better processing of the MS Word. For this, you should open the File. Then, you will get word options. After this, you should click on the Add-ins tab. Now, you have to click on the “Go” button which is closer to the drop-down box Manage Com-in Add. Here, you should click on the checkbox just to disable all the add-ins. Then, you should click on the okay button to continue.

2. Check Incompatible Device Drivers:

It is necessary that you should have the latest device drivers of Microsoft and Windows on your PC. For the latest updates, you should go to the settings and then just select update and security. After this, you should click on the automatic update and security. This will automatically update all the latest drivers of Microsoft and Windows on your PC.

3. Do Not Close the Word Document Without Saving Work:

This is one of the silly mistakes which many people have done in their life. That is, they shut down the Microsoft Word without saving their work. This method affects the software of Microsoft Word. Hence, it is advised that you should always close the Microsoft word when you save all the data for the proper functioning of the Word application. If you apply this procedure then this error will not comes in future.

4. MS Office Recovery Application:

To fix this issue, you should go for the Microsoft Office Recovery Application feature. This feature will help you to bring back all the unsaved data.

For this, first you have to click on Start option. And then you should click on All Programs and then select Microsoft Office Tools. After this, you will find -MS Office Application Recovery. At this point, you have to select the document which is not responding from the list of recently running office applications. At last, you have to click on “Recover Application”. This will help you to recover all the lost documents.

The above method will help you to fix the MS Word Not Responding Issue. If you need assistance, then you should call the customer care of MS Office through www.office.com/setup.

Visit Here – How To Troubleshoot If Excel File Couldn’t Open in Protected View?

How to Resolve Office 2016 Error Code 1224-28?

MS Office is the amazing software which helps the users in many ways like editing, creating text document, making spreadsheets etc. And it can be easily install in your device through www.office.com/setup. But sometimes the users faces issues while installing MS Office. In this blog, you will read the solution of the Office 2016 error code 1224-28.

Causes Office 2016 Error Code 1224-28 : office.com/setup

The causes of this error are antivirus software might be blocking the office installation, due to Proxy setting or internet connectivity can result in this issue, if there is pre-existing version of Office, may be because of Temporary and log files, if Windows update is not installed properly, and also due to removal of previous Office suite can interrupt the installation of newer version.

Solution to Fix Office 2016 Error Code 1224-28:

1. Repair Microsoft Office:

You have to go to the Control Panel and open it by using Start option. Then, you need to click on the Programs and after this, just select Programs and Features. Here, you should look for the office product which you want to repair and then just click on it. Now, you should click on Change option. At last, you should choose the Quick Repair option and then just click on Repair.

2. Remove Office:

By using Start option, you should go to the Control Panel. After this, click on Programs and then just select Programs and Features. Now, you have to select Office Suite and then click on Remove option.

If you find the installation is failed and the error is not fixed then you should manually remove it.

3. Manually Remove Office:

You should find the Office 16 installation folder which is usually located in C:\Program Files\. Now, you have to right-click on the Microsoft Office 16 folder, just select it and then remove it.

Remove Office Scheduled Tasks:

You should go to the command prompt window and open it as an administrator. Then, just type the following commands and tap on Enter key after each command:

schtasks.exe /delete /tn “\Microsoft\Office\Office Automatic Updates”

schtasks.exe /delete /tn “\Microsoft\Office\Office Subscription Maintenance”

schtasks.exe /delete /tn “\Microsoft\Office\Office ClickToRun Service Monitor”

End Click-to-Run tasks By using Task Manager:

First, you should open the task manager and then just click on the process tab. If the .exe and setup is running, then right-click each one and then you have to click on End task when you select each process.

Visit Here – Easy Way To Fix Excel Cell Content Not Visible Issue

Remove Office files:

You should open the Run dialogue box by pressing Window + R key together. Then in the box, you should type %ProgramFiles%, and just click on OK button. Here, you need to delete the “Microsoft Office 16” folder and then Delete the “Microsoft Office” folder. After this, open the Run dialog box, and then type %ProgramFiles(x86)% and just click on OK button. Now, just Delete the “Microsoft Office” folder.

Delete Office Registry Sub Keys:

First, open Registry Editor and just remove the following registry subkeys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\AppVISV

HKEY_CURRENT_USER\Software\Microsoft\Office

After this, just delete the Office key.

When the above procedure complete, then you should again download and install the Microsoft Office in your device. Now, it will work properly.

If you are still facing the error, then you can call the customer care of MS Office via www.office.com/setup.

If Data Lost In Excel! How You Can Recover it?

Sometimes when you are working on Excel Application, your data get lost or disappear. In this situation, the user gets worried and irritated. So, in this blog you will read how you can get lost data in Excel application easily. But if the user of MS Office needs assistance, then they can anytime contact to the customer care of MS Office via www.office.com/setup.

Reasons of Excel Spreadsheet Data Loss : office.com/setup

The reason of Excel Spreadsheet data gets disappear are format conversion, unsaved work, in case of cell formatting, and also when cells are merging.

Steps To Recover Lost Data in Excel:

  1. Recover With Restore Previous Version Option: For this, first open the File Explorer on your computer and then just search for your Excel file. Now, you have to choose your lost data Excel file and just right-click over it. Then, from the list of options you have to select “Properties” option. Here, you have to click on the “Previous Versions” tab and then you should select the preferred version in which you want to get back to your Excel file. At the end, you have to click on the “Restore” button. With these steps, you can restore lost Excel file.
  2. Use Excel Repair Option: You should restart your computer system before you start the repair functions. Then, you should go to Control Panel and just click on Programs and Settings option. Here, you should find Office and then right-click on it. After this, from the options you should click on Change. Now, you will view a Repair option appears on your screen and then just click on Repair. At last, you should open the MS Excel file just to check data is fixed or not.
  3. Recover With Excel “Recent Option”: First, you have to launch MS-Excel and then you should select the “file” option from the top. After this, you should press on “open”. Now, you should select the “recent” option and then just select on recover unsaved workbook.
  4. Try Microsoft Office Application Recovery Option: For this, you have to choose All Programs after clicking on the Start option. Now, you should select Microsoft Office. After this, you have to choose Microsoft Office Tools. Then, you have to select Microsoft Office Application Recovery. Here, you have to choose Microsoft Office Excel in the resulting dialog box. At this point, you should click on Recover Application. Note, this procedure will take some time to complete. At last, you have to respond to the Send Report To Microsoft prompt. Here, this tool will quit the Excel and after this, it will allow your Excel application to restart with a list of recoverable workbook.

Read More – How To Troubleshoot if “Photoshop Unable to Create New Files or Open Existing Ones?

The above method will help you to recover the lost data in Excel application. But if you need any help or support, then you can anytime contact to the customer care of MS Office through www.office.com/setup.  The experts of Microsoft are available for 24/7 for its customer and try their level best to solve the query of the user.

How To Move Virtual Memory to Another Drive on Window 10?

Windows 10 provide you many useful functions and features like virtual memory. Virtual memory is the paging file which is used to store unused pages and modified pages in RAM to the hard drive to prioritize more physical memory. You can move the virtual memory to another drive as this will improve the performance of your device. If in case, you find any kind of problem then you can call the expert of Microsoft via office.com/setup. In this blog, you will read the procedure to move virtual memory to another drive on Windows 10.

Move Virtual Memory to Another Drive:

 If you want to move virtual memory to another drive then you should go to the Settings option in your computer system. Then, you have to select the System option and after this, you should click on the About button. Now, under ‘Related settings’ field which is at the right-hand side of the screen, you should select ‘System info’. Here, you should choose ‘Advanced system settings’ which is on the right-hand side of the screen. Then, under the ‘Performance’ field, you have to select the Settings tab. Now, just go to the Advanced button. And under ‘Virtual memory’ field, you should select the Change tab. Here, you have to uncheck the box of ‘Automatically manage paging file size for drivers’. Then under ‘Paging file size for each drive’ field, you have to choose to drive C. Here, you should select the option No paging file. After this, you have to click on the Set tab and then click on Yes option. Now, you should go to the drive which you want to use for paging file. Then, you have to go to ‘System managed size’. After this, just click on the Set button and then hit on OK tab. Here, you should select the Apply tab and then click on the OK tab. At the end, you should reboot your computer system.

After you complete the process, Windows 10 will make a new pagefile.sys file automatically, which contains the virtual memory content in the new location just to improve the performance.

Read Also – How to Insert GIF in MS PowerPoint?

Verify Virtual Memory

If in case, you want to verify the virtual memory, then you have to go to the File Explorer and just launch it. Now, you have to select the This PC which is in the left-hand side of the screen. Then, under the Devices and drives field, you should double click to launch the drive which is presently saving the paging file. Now, you should select the View button. After this, you should tick the box of Hidden items. Here, you have to click on the Options tab. Now, you just choose the View button. Then under Advanced settings’ field, you have to uncheck the box of ‘Hide protected operating system files’. After this, go to the OK tab and just click on the Apply tab. Now, you should select the OK tab and just verify the ‘pagefile.sys’ file is present.

This method helps to move virtual memory to another drive in Window 10. If you need assistance, then visit to the site of Microsoft Office via www.office.com/setup.

How to Troubleshoot MS Office Error Code 30180-28?

MS Office software has now become the need of every organization as it has all the application which makes the task of the customer easy and faster. You can install this useful software in your device through www.office.com/settup. But sometimes the user faces difficulty while installing MS Office. In this blog, you will read the solution of the MS Office Error Code 30180-28.

Solution To Fix MS Office Error Code 30180-28 – Office.com/setup

1. Disable antivirus:

1. For this, first open antivirus console.

2. Then, you should click on Settings option.

3. Now, you should select real time protection.

4. After this, you should turn off the Real time protection.

5. And then you should select until next reboot.

This method will fix the issue, and then you should try to install MS Office again.

2. Disable Proxy settings:

1. You should press windows key and R key altogether.

2. Now, you should type “appwiz.cpl”.

3. Then in internet properties, you should click on connection option.

4. Here, you should select LAN settings.

5. After this, you should uncheck the proxy settings.

6. At last, click on Apply option and OK button.

3. Re-enable the Windows Installer file settings:

1. First, press Windows key+ R key to open the run command dialog box.

2. Then in the run command box, you should type “services.msc”.

3. Now, you should right click on the “windows installer” file and then you should click on “properties” option.

4. At last, just click on the Start option to enable Windows installer.

4. Perform disk clean up:

  1. First, you should press Windows + R key altogether and then just type “cleanmgr” in the run command box.
  2. Then, you should Select C Drive.
  3. Now, you should select the temporary file folders.
  4. After this, click on Ok button to move further and then you have to clean up the temporary files.

5. Disable Firewall Setting:

  1. You should click on the Windows Firewall.
  2. After this, you should click on the Control Panel option.
  3. Then in the search box, you should type firewall, and then click on Windows Firewall.
  4. Now, you should click on Turn Windows Firewall on or off.
  5. Here, you are required to type the password of the administrator or you can provide confirmation.
  6. Then, click on the Turn off Windows Firewall.
  7. At last, you should click on the OK button.

6. Remove MS Office:

  1. First, press Windows + R key altogether to open the rum command.
  2. After this, you should type “appwiz.cpl” in the window.
  3.  Then, you should select Microsoft office under the installed program list.
  4. Here, you should click on “uninstall/change” just to delete MS Office.
  5.  Again try to reinstall MS Office.

Read Also – How To Run Microsoft Office Picture Manager on Window 10?

7. Install MS Office:

  1. You should open MS Office my account login page.
  2.  Then, log in to your Office account just by using your registered MS Office email ID and password.
  3. After this, click on install option.
  4.  Now, you should click on Save option and then you have to run the downloaded setup file.
  5. At the end, you have to click on close button when the installation process finishes.

The above method will help you to fix MS Office Error Code 30180-28. In case, you want more details, then you can go to the site of MS Office through www.office.com/setup.

Some Common Excel Error and How to Fix it?

Microsoft Office is great software with amazing applications like Excel, Word, PowerPoint, Outlook and One Drive etc. All these apps of MS Office perform different functions. It is very easy to use and you can easily install this software through www.office.com/setup. MS Excel is the well known application used for creating spreadsheets, keeping accounting data, and tracking day-to-day activities. It is used in offices, schools, homes and also for business purpose. But, when user uses this application of Excel, they encounter some errors. And it is very necessary to fix these errors. In this blog, you will read about some common errors of MS Excel and how you can fix it with ease.

Read Also – How One Drive Can Secure Your Data In Cloud?

What are the Common Excel Error and its Solution? Office.com/setup

  1. ##### Error: It is the common error which the user faces is a cell filled with hashtag characters. This means that column is not wide to show the data which you have entered. You can easily fix this error, by increasing the column width so that the data can be easily entered in the spreadsheet.
  2. #NUM Error: The NUM error basically occurs when you add the invalid number to the formula then you’ll receive the NUM error on your spreadsheet. It also occurs when the numeric value is too small or large. You can fix this error; you just have to check that you have entered any formatted data such as currency, dates, or special symbols in the formula. You just have to delete the invalid characters from the formula and just keep only numbers.
  3. #VALUE! Error: The #Value error occurs in Excel when there are spaces, characters, or text in the formula where it should be the number. You can fix this error by just checking the formula and make sure you use only numbers in the formula.
  4. #REF! Error: The #REF error occurs in Excel when a formula contains incorrect cell references. You can fix this error, for this you should be careful while pasting a set of cells and there should be no formulas which get affected on deleting a cell. By mistake, if you have deleted a cell, then you can click the undo button (Ctrl+Z) just to recover them.
  5. #DIV/0! Error:This error occurs when you divide a formula by zero  or an empty cell in Excel. As it is not possible to divide by zero. You can fix this error, you should change the value of a cell to the value which is not equal to zero or you can also add value if the cell is blank.
  6. #Name! Error: This error occurs when Excel is not understanding the name of the formula which you are trying to run, and also occur when excel cannot compute one or more values which entered in the formula itself. You can fix this error by just checking the spelling mistakes in the formula. And you should also type the Excel functions in lower case when you enter a formula, as the Excel will automatically convert it to upper case.

These are some of the common Excel error and their solution. But in case, if you are still facing problem then you can visit to the site of MS Office via www.office.com/setup for details.

How you can Schedule A Meeting in Outlook?

Microsoft Office is the software which has so many applications like MS Word, Excel, PowerPoint and Outlook etc. All the applications has different task which makes the work comfortable for the user. With this you can do formatting, editing, creating text document, and also use to make presentation etc. You can install this software through www.office.com/setup.

When you schedule a meeting in Outlook, the people will receive an invitation email with the meeting details. The other person can accept or decline the meeting invitation. Outlook first adds the meeting to your Outlook calendar, and then it keeps track of your attendees and then sends a reminder before the meeting starts.

How to Send a Calendar Invite in Outlook?

For this first you have to select the Home tab and then New Items > Meeting. You can also press Ctrl+Shift+Q. Now in the Meeting invitation, you have to enter a description of the meeting in the Title text box. Then in the text box, you have to enter the email addresses of each attendee who want to attend the meeting. In Outlook 2016 and 2013, you have to enter the email addresses in the To text box. And in the Optional text box, you have to enter the email addresses of people not who are not attending the meeting. You have to choose a Start time and End time for the meeting. If you want to block the entire day on your calendar for the meeting, you have to select All day. In the Location text box, you have to enter the address of the room where the meeting will be held. In the Message area, you have to enter other information. By default, it will ask for a response and it will also gives the recipient the option for a new time for the meeting. But if you want to change these options, you have to select the Meeting tab, and then select Response Options. At the end, just select Send.

How to Set Up a Recurring Meeting?

For this, you have to select the Home tab, then you have to select New Items > Meeting. Now in the Meeting invitation, you have to enter the Title, Required attendees, Optional attendees, Location, and a message which describe the purpose of the meeting. After this, just select Make Recurring. Now in the Appointment Recurrence dialog box, you have to enter the Start time, End time, and Duration of the meeting. In the Recurrence pattern section, you have to choose when the meeting will reoccur. In the Range of recurrence section, you have to choose a length of time the recurring meetings will continue and then select OK button. In the Meeting invitation, you have to select Send.

For more details, you can visit to the official website of MS Office through office.com/setup. You can also call on their toll free number.