{"id":7307,"date":"2017-12-19T14:04:11","date_gmt":"2017-12-19T13:04:11","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=7307"},"modified":"2024-02-06T19:19:51","modified_gmt":"2024-02-06T18:19:51","slug":"use-external-data-source-create-new-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-external-data-source-create-new-pivot-table\/","title":{"rendered":"Use An External Data Source To Import Data Into An Excel Pivot Table"},"content":{"rendered":"<p>When creating an <strong>Excel\u00a0<a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a>,\u00a0<\/strong>what happens if your data source is in another location?<\/p>\n<p>Would you have to copy your data into the same <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" title=\"spreadsheet\" data-wpil-keyword-link=\"linked\">spreadsheet<\/a>?<\/p>\n<p>Well, NO!\u00a0 You can simply use the\u00a0<strong>External Data Sources <\/strong>feature\u00a0in your Pivot Table and Excel will magically import the data for you!<\/p>\n<p>You can import data into your Pivot Table from the following data sources:<\/p>\n<ul>\n<li>Excel workbook<\/li>\n<li>Microsoft Access database<\/li>\n<li>SQL Server<\/li>\n<li>Analysis Services<\/li>\n<li>Windows Azure Marketplace<\/li>\n<li>OData Data Feed<\/li>\n<\/ul>\n\n<p>For our example, we will import data using two data sources, an <strong>Excel workbook<\/strong> and an <strong>Access file<\/strong>.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/dGuXCB4_DXQ?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-external-data-source-create-new-pivot-table\/#Want_to_know_how_to_Import_Data_into_Microsoft_Excel\" title=\"Want to know how to Import Data into Microsoft Excel?\">Want to know how to Import Data into Microsoft Excel?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-external-data-source-create-new-pivot-table\/#Import_from_another_Excel_Workbook\" title=\"Import from another Excel Workbook:\">Import from another Excel Workbook:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-external-data-source-create-new-pivot-table\/#Import_From_Microsoft_Access_and_into_Excel\" title=\"Import From\u00a0Microsoft Access and into Excel:\">Import From\u00a0Microsoft Access and into Excel:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-external-data-source-create-new-pivot-table\/#Import_from_another_Excel_Workbook-2\" title=\"Import from another Excel Workbook:\">Import from another Excel Workbook:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-external-data-source-create-new-pivot-table\/#Import_From_Microsoft_Access_and_into_Excel-2\" title=\"Import From\u00a0Microsoft Access and into Excel:\">Import From\u00a0Microsoft Access and into Excel:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-external-data-source-create-new-pivot-table\/#More_Ways_to_Import_External_Data_into_an_Excel_Pivot_Table\" title=\"More Ways to Import External\u00a0Data into an Excel Pivot Table:\">More Ways to Import External\u00a0Data into an Excel Pivot Table:<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Want_to_know_how_to_Import_Data_into_Microsoft_Excel\"><\/span><em><strong>Want to know how to Import Data into Microsoft Excel?<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/712E6Mr07Pc\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/712E6Mr07Pc?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/ImportingData.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/ImportingData.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">ImportingData.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/zYrbldjJnl8\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/zYrbldjJnl8?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/ImportingData.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/ImportingData.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download the youtube excel practice file<\/strong><\/span><span class=\"postTitle px-3\">ImportingData.xlsx<\/span><\/a><\/p>\n<\/div>\n<h2><\/h2>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Import_from_another_Excel_Workbook\"><\/span><span style=\"color: #0000ff;\"><strong>Import from another Excel Workbook:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Excel-Source.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7309\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Excel-Source.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"1364\" height=\"509\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Excel-Source.jpg 1364w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Excel-Source-300x112.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Excel-Source-1024x382.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Excel-Source-768x287.jpg 768w\" sizes=\"(max-width: 1364px) 100vw, 1364px\" \/><\/a><\/p>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Import_From_Microsoft_Access_and_into_Excel\"><\/span><span style=\"color: #0000ff;\"><strong>Import From\u00a0Microsoft Access and into Excel:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Access-Source.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7308\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Access-Source.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"1361\" height=\"689\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Access-Source.jpg 1361w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Access-Source-300x152.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Access-Source-1024x518.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-00-Access-Source-768x389.jpg 768w\" sizes=\"(max-width: 1361px) 100vw, 1361px\" \/><\/a><\/p>\n<p><strong>Wondering how this is even possible? Read on!<\/strong><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-files.zip\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-files.zip\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download files<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">External-Data-Source-files.zip<\/span><\/a><\/p>\n<h2><\/h2>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Import_from_another_Excel_Workbook-2\"><\/span><span style=\"color: #0000ff;\"><strong>Import from another Excel Workbook:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span>\u00a0 Go to\u00a0<em><strong>Insert &gt; Tables &gt; PivotTable<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7310\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-01.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"310\" height=\"134\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-01.jpg 310w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-01-300x130.jpg 300w\" sizes=\"(max-width: 310px) 100vw, 310px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0Select\u00a0<strong>Use an external data source<\/strong>\u00a0and click <strong>Choose Connection.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7311\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-02.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"387\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-02.jpg 387w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-02-300x268.jpg 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span>\u00a0Select <strong>Browse for More<\/strong><strong>.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7312\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-03.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"486\" height=\"493\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-03.jpg 486w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-03-296x300.jpg 296w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span>\u00a0Select the\u00a0<strong>Excel file\u00a0<\/strong>with your data.\u00a0Click\u00a0<strong>Open.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7313\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-04.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"669\" height=\"507\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-04.jpg 669w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-04-300x227.jpg 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span>\u00a0Select the first option and click <b>OK.<\/b><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7314\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-05.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"492\" height=\"236\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-05.jpg 492w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-05-300x144.jpg 300w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span>\u00a0Click <b>OK.<\/b><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-06.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7315\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-06.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"387\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-06.jpg 387w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-06-300x268.jpg 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong><\/span>\u00a0In the\u00a0<strong>VALUES <\/strong>area\u00a0put in the\u00a0<em><strong>Sales<\/strong>\u00a0<\/em>field,\u00a0for the\u00a0<strong>COLUMNS\u00a0<\/strong>area\u00a0put in the <b><i>Financial Year\u00a0<\/i><\/b>field, and\u00a0for the\u00a0<strong>ROWS\u00a0<\/strong>area\u00a0put in the <b><i>Sales Month\u00a0<\/i><\/b>field<\/p>\n<p>Your Pivot Table is ready from the Excel data source!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-07.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7316\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-07.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"760\" height=\"555\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-07.jpg 760w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-07-300x219.jpg 300w\" sizes=\"(max-width: 760px) 100vw, 760px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Import_From_Microsoft_Access_and_into_Excel-2\"><\/span><span style=\"color: #0000ff;\"><strong>Import From\u00a0Microsoft Access and into Excel:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span>\u00a0Now let us try for an Access data source!<\/p>\n<p>Go to\u00a0<strong>Data &gt; Get External Data &gt; From Access<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-07b.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7326\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-07b.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"426\" height=\"219\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-07b.jpg 426w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-07b-300x154.jpg 300w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0Select the\u00a0<strong>Access Database Source file in your desktop or company file path.\u00a0<\/strong>Click\u00a0<strong>Open.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-08.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7317\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-08.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"669\" height=\"507\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-08.jpg 669w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-08-300x227.jpg 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span>\u00a0Select\u00a0<strong>PivotTable Report<\/strong>\u00a0and click <strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-09.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7318\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-09.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"307\" height=\"270\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-09.jpg 307w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-09-300x264.jpg 300w\" sizes=\"(max-width: 307px) 100vw, 307px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:\u00a0<\/strong><\/span>In the\u00a0<strong>VALUES <\/strong>area\u00a0put in the\u00a0<em><strong>Sales<\/strong>\u00a0<\/em>field,\u00a0for the\u00a0<strong>COLUMNS\u00a0<\/strong>area\u00a0put in the <b><i>Financial Year\u00a0<\/i><\/b>field, and\u00a0for the\u00a0<strong>ROWS\u00a0<\/strong>area\u00a0put in the <b><i>Sales Month\u00a0<\/i><\/b>field<\/p>\n<p>Your Pivot Table is ready from the Access data source!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-10.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"alignnone size-full wp-image-7319\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-10.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"764\" height=\"558\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-10.jpg 764w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/10\/External-Data-Source-10-300x219.jpg 300w\" sizes=\"(max-width: 764px) 100vw, 764px\" \/><\/a><\/p>\n<h2><\/h2>\n<h2><\/h2>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"More_Ways_to_Import_External_Data_into_an_Excel_Pivot_Table\"><\/span><strong><span style=\"color: #0000ff;\">More Ways to Import External\u00a0Data into an Excel Pivot Table:<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can also use this functionality to get data from other source types:\u00a0<strong>SQL Server<\/strong>, <strong>Analysis Services<\/strong>, <strong><a class=\"wpil_keyword_link\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/download-office\" target=\"_blank\" rel=\"noopener nofollow\" title=\"Windows\" data-wpil-keyword-link=\"linked\">Windows<\/a> Azure<\/strong>, and <strong>oData Data Feed<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/pivotothersources.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Use An External Data Source To Import Data Into An Excel Pivot Table\"  class=\"size-full wp-image-7564 aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/pivotothersources.jpg\" alt=\"Use An External Data Source To Import Data Into An Excel Pivot Table\" width=\"577\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/pivotothersources.jpg 577w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/pivotothersources-300x160.jpg 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-the-difference-from-previous-months-with-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Show The Difference From Previous Months With Excel Pivot Tables<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-percent-row-total-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Show The Percent of Row Total With Excel Pivot Tables<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/show-percent-difference-previous-years-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Show The Percent of Difference From Previous Years With Excel Pivot Tables<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>When creating an Excel\u00a0Pivot Table,\u00a0what happens if your data source is in another location? Would you have to copy your data into the same spreadsheet? Well, NO!\u00a0 You can simply use the\u00a0External Data Sources feature\u00a0in your Pivot Table and Excel will magically import the data for you! You can import data into your Pivot Table [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17278,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4,17,18,42],"tags":[313,154,178,139],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7307"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=7307"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17278"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=7307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=7307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=7307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}