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 You Can Transfer Excel Contacts to IPhone Manually?

How You Can Transfer Excel Contacts to IPhone Manually? Office.com/setup

If the user wants to access their Excel contacts to IPhone, then you should read this blog. But if you want any kind of support then just contact to the expert of MS Office via www.office.com/setup.

Method to Transfer Excel Contacts To IPhone Manually: office.com/setup

Method 1. Import Excel Contacts To iPhone by Using iTunes:

For this, you should export contacts from excel to CSV format. Then, import CSV contacts into the Outlook application. After this, just synchronizing those contacts from Outlook app to iPhone by using iTunes.

1.Export Contacts From Excel:

First, from the menu you should click on the “File” option and then select “Save As” option. After this, click on the drop-down menu of “Save as type” and then select “CSV (Comma delimited)” format file type. Now, you should name the CSV file and tap on “Save” button. Here, you will get the confirmation box which prompts, you want to use the CSV file or not. Then, just hit the “Yes” button. You must remember the location of this CSV file as it will use it again when you import the contacts to outlook.

2. Import Contacts to Outlook:

You should open your outlook program. Then, follow this path: “File > Open & Export > Import/Export > Import From Another Program or File > Next”. After this, click on the “Comma Separated Values” from the list of various file formats and then click on the Next. Here in the opened screen, you should search for the CSV file which you have exported and then just double-tap on it. Just ignore the duplicate contacts and click on the Next option. After this, choose the folder where you want to import Excel contacts. Now, you should import Excel contacts in the already existing folder and click on the “Next” option. At the end, you should put a checkmark next to the name of the CSV file and then click on the “Map Custom Fields” option. At the end, you should tap on the finish button just to import Excel contacts into Outlook.

3. Sync With iPhone Via iTunes:

You should connect your iPhone with your PC just by using the USB cable. Then, you should start the iTunes app on your PC. After this, you should click on the iPhone device name which is there on the right side of the iTunes app. Then, you have to click on the “Info” tab from the horizontal menu bar. After this, you should put a checkmark next to the check box of “Sync Contacts With”. Here, you should select your email account in the Outlook to which you want to import your Excel contacts. Then, you have to click on the apply button just for transferring up the contacts to the iPhone. At this point, you should click on the “Sync” button according to the status of how the iTunes and iPhone are configured.

Also Read – How You Can Empty Spam and Trash Fast in Gmail?

Method 2. Import Excel Contact To iPhone by Using iCloud:

For this, you should convert your Excel file into VCF format because the iCloud Application import the only file of VCF format.

 1: You should convert your XLSX file in the proper format. Then, you have to save your Excel workbook in the CSV format. After this, press the Win+R key and in the opened Run window you should type the word ‘Run’ and tap on Enter button. Here from the Contacts windows navigation bar, you should select the “Import” option. Now, you should choose the option for Comma Separated Value Field or CSV. Then, you have to browse on the folder path where the .csv file is saved. Just choose the CSV file and click on the Next option. After this, Map the appropriate fields and tap on the Finish button. At the end, select the Export option as vCard and then click on the Export button.

 2: First, you should log in to the iCloud.com page just by using your Apple ID & Password. Then, you have to click on the Contacts icon just to import contacts of the Excel spreadsheet into iPhone. Now, click on  the Gear Icon and then choose the Import vCard option. Here, from the folder path in which the VCF file is saved just click on the Open button. You will see all contacts will get uploaded. Then, in the iPhone Device you should open the Contacts Section. When the iCloud accounts synchronize with your iPhone device then you can see the converted contacts from Excel spreadsheet to iPhone.

For details, you should visit to the site of MS Office via www.office.com/setup.

Must Visit – Office.Com/Myaccount

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.

What are the Causes and Solution to Fix Excel File Not Loaded Completely?

Excel is the very useful and easy application of MS Office. You can use this application on all devices like Window OS, Mac, Computer, Laptop and Android Phones. The user can install this application just by going to the official site of MS Office through www.office.com/setup. Sometimes user’s faces issue like File not loaded completely. The main reason of this error is when the user crosses the row limitation in Excel, when the user opens a spreadsheet which hides the maximum worksheet limit and also when you import CSV data into Excel sheet. So, in this blog you will read the solution to fix Excel File Not Loaded Completely.

Solution To Fix MS Excel “File Not Loaded Completely” Error: office.com/setup

1. Open Spreadsheet With Alternative Options: You should try to open your Excel spreadsheet with other alternative Excel software and after this, just reduce the number of rows and columns which are there in the file. Because this spreadsheet can also be easily open with your regular MS Office application suite program.

2. Import Spreadsheet Into Access: For this, first you should open a blank database file in your Excel application. Then, you have to click on the External Data and then tap on Excel. After this, you should click on the browse option just for selecting the Excel spreadsheet. Then, you have to click on the Import the source data option into the new table in the current database. Now, you should click on the OK button. Here from the Import Spreadsheet Wizard window, you should click on the Next and Finish option. Now, you can view your spreadsheet content in the database table. At this point, you can remove extra or unwanted table rows and after this, export the modified file back to your Excel application like a spreadsheet.

3. Split A CSV File Before Importing It: In case, you are getting the error like File not loaded completely when you are trying to import a CSV file. In this situation, you should split your CSV file with some of the reliable Split CSV file program. Now, you can import your split CSV file in the distinct Excel worksheets.

4. Repair Corrupted Excel File: For this, you should click on the File. Then from the Open option, you should select the excel file which is not opening and show you the error not loaded completely. After this, you should click on the arrow sign which is there in the open button. Here from the drop-down list, you should select the Open and Repair option. If in case, the repair option is available then you should click on it.

5. Repair MS Excel File with Excel Repair Tool: If the above solution, do not fix the issue then you should go with the MS Excel repair tool. It helps to repair corrupted Excel workbooks. And it is quite easy and convenient to use and also supports all Excel version.

Visit Here – How You Can Save Files to ICloud Drive on your Mac?

The above method will help you to solve the Excel File Not Loaded Completely error. In case, the user find any kind of issue then they can anytime contact to the expert of MS Office through www.office.com/setup. The executives are experienced and always available to solve your queries.

If Filter is not Working in Excel! How to fix it?

If your Filter function is not working in Excel, then you don’t have to worry about it. In this blog, you will read the solution if filter is not working in Excel. But if you want technical support, then you can anytime contact to the expert of Microsoft Office through www.office.com/setup.

Solution To Fix If Filter is Not Working in Excel : office.com/setup

 1. Excel Filter Not Working With Blank Rows:

 The biggest problem with Excel filter function is that it does not work with the blank rows. It doesn’t count the cells with the first blank spaces. To fix this, you just have to select the data which you want to filter out. Then from the “data” tab, you should select the “Filter” option. Here, all the items are visible in the filter checkbox list. After this, you just choose the cell ranges or multiple columns before you use the filter function.

2. Proper Selection Of Data:

If you want to remove the blank rows from the selected filter area. For this, first you should turn on the filter and then you have to click on the drop-down arrow which is there in any columns just to show the filter list. You just have to remove the check sign. And in the bottom of the filter list, you just choose the ‘(Blanks)’ option and click on OK. Now, the blank rows will display on your computer screen. Remember, the row number of each blank row displays in blue color. To delete these blank rows, you should select these rows first and just right-click on the blue color row number. At last, you have to select the Delete option to delete the select blank rows. After turning off the filter, you can now see the rows are removed.

Read Also – Incredible Way to Fix Poor Wi-Fi Connection on Mac OS Sierra

3. Check The Column Headings:

First, you should check the data which contains only one row of column headings. If you want multiple lines for the heading, then in the cell you should type the first line. Now, you have to press “ALT + ENTER” option just for typing in the new line of the cell. Remember, the Wrap Text function works properly in formatting the cells.

4. Check For Merged Cell:

Excel Filter Function will not work if you have merged cell in the spreadsheet. To unmerge the cells, you should go to the Home tab and then go to the Alignment group. After this, you should click the down arrow which is there across Merge & Center and then you have to choose the Unmerge Cells option.

5. Check For Errors:

You should check that your data does not have any error because it can damage your Excel application to apply filters. To remove the errors, you should use the filters to fetch them. Normally, they are listed at the bottom of the list so just scroll down. After this, just choose the error and then click on the OK button. When you locate the error, just fix it or delete it and then just clear up the filter.

The above methods will you to fix the issue if Filter is not working in Excel. To know more, just go to the site of MS Office through office.com/setup. You can also call the expert of Microsoft team anytime from anywhere for assistance.

How to Find, Fix and Remove Broken Links in MS Excel?

Excel Broken Link is when an Excel sheet is linked with different a file which has data like formulas, codes, etc. But if these source files gets deleted, or corrupted then the link which is related to a specific workbook will automatically gets break down. Then these broken links cannot be able to perform their function. And if you want to install Excel application in your device then you should go to the official website of MS Office via office.com/setup.

The causes of the Broken Links in Excel are when the source folder gets deleted and also when the Files/folders shifted to another location. In this blog, you will read how to find, fix and remove broken links in Excel.

Find Broken Links In ExcelWww.office.com/setup

1. Using Find And Replace Method:

First, you have to open your Excel sheet which is showing broken link error. Now, you should press the Ctrl+F button from your keyboard. Here, it will open the Find and Replace dialog box. Now in the open dialog box, you have to go to the Find what box. Then you should enter your file extension which is linked with the cell. After this, in the “within” box option, you have to choose the option “Workbook”. In the Look in box, you should choose the “Formulas” option. At the end, you should press the find all button. Now you will find Excel broken links. After this, you just have to replace the broken link with the correct new link.

2. Through Cell Relationship Diagram:

First, from the menu bar you have to choose the Files and then click on Options tab. Now in the open window, you have to click on the Add-ins tab. Then from the drop-down, you have to choose the COM add-in and then hit on the ok button. In the opened com Add-in dialog box, you should choose the “Inquire”. After this, the tab of Inquire will added in the Excel Ribbon. Now from the diagram group, you should choose Cell Relationship. Then in the next window of the cell relationship diagram will display on the screen. You should choose the options from the opened dialog box and then tap on OK button. Now you will see the diagram on your Excel screen. Here, you can also zoom in to see the links between one cell to another cell, or the link between one cell to another worksheet. Now, you can see cell relationship diagram which has all the included links. In this, you can also check the broken links in your Excel workbook.

Read Also – What To Do If You Get OneNote Sync Error?

Fix Broken Link In Excel:

 For this, first you should take the backup copy of your Excel workbook. Then, open your Excel workbook which has broken link issue. After this, go to the Data tab and then hit on the Edit Links option. If in case, you do not get the Edit Links option this means that your workbook do not have any links. Here from the Source file box, you have to choose the broken link which you require to fix. After this, click on the Change Source option. Now, you have to search the location of the Excel file which has the source of your linked data. Then just choose the new source file and click on the Change Source option. At last, just click on the Close option.

Remove Broken Links In Excel:

First, open the Excel workbook which has the broken link. Then you should go to the Data tab, and tap on the Edit Links button. Now within the Source file box, you should choose the broken link which you want to remove. After this, you have to click on the Break Link button. At last, you should click on the Close option.

For more detail about Excel Application, just go to the site of MS Office via www.office.com/setup