{"id":27785,"date":"2019-09-12T10:15:10","date_gmt":"2019-09-12T09:15:10","guid":{"rendered":"https:\/\/www.okappy.com\/?post_type=avada_portfolio&#038;p=27785"},"modified":"2019-09-13T07:31:04","modified_gmt":"2019-09-13T06:31:04","slug":"dynamically-linking-data-between-okappy-microsoft-excel","status":"publish","type":"avada_portfolio","link":"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-microsoft-excel\/","title":{"rendered":"Dynamically linking data between Okappy and Microsoft Excel"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;margin-bottom: 0px;margin-top: 0px;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"margin-top:0px;margin-bottom:20px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-1 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"margin-top:0px;margin-bottom:31px;\"><h1 class=\"title-heading-left\" style=\"margin:0;\">Dynamically linking data between Okappy and Microsoft Excel<\/h1><\/div><div class=\"fusion-text fusion-text-1\" style=\"transform:translate3d(0,0,0);\"><p>Certain version of Microsoft Excel can now integrate with Okappy and pull in your information periodically into an Excel sheet where you can then manipulate the data and generate management information.<\/p>\n<p>Read on to find out how to connect Microsoft Excel with Okappy.<\/p>\n<\/div><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-2 fusion-sep-none fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-bottom:31px;\"><h3 class=\"title-heading-left\" style=\"margin:0;\">1) First check you have a compatible version of Microsoft Excel<\/h3><\/div><div class=\"fusion-text fusion-text-2\" style=\"transform:translate3d(0,0,0);\"><p>To check that you have a compatible version of Microsoft. Click the <strong>Data<\/strong> option in the toolbar and then ensure you have the option to <strong>Get data<\/strong> <strong>From Web<\/strong>.<\/p>\n<p><img class=\"lazyload size-large wp-image-27787\" title=\"Microsoft Excel Dynamically Linking to Okappy\" src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-1024x576.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-1024x576.png\" alt=\"Microsoft Excel Dynamically Linking to Okappy\" width=\"1024\" height=\"576\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27576%27%20viewBox%3D%270%200%201024%20576%27%3E%3Crect%20width%3D%271024%27%20height%3D%273576%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-200x113.png 200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-300x169.png 300w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-400x225.png 400w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-600x338.png 600w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-768x432.png 768w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-800x450.png 800w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-1024x576.png 1024w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-1200x675.png 1200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel.png 1920w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<\/div><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-3 fusion-sep-none fusion-title-text fusion-title-size-three\" style=\"margin-top:0px;margin-bottom:31px;\"><h3 class=\"title-heading-left\" style=\"margin:0;\">2) Generate your report data formula within Okappy<\/h3><\/div><div class=\"fusion-text fusion-text-3\" style=\"transform:translate3d(0,0,0);\"><p>From within Okappy, generate your <strong>Microsoft Excel URL<\/strong> by<\/p>\n<ul>\n<li>Clicking <strong>Reports<\/strong><\/li>\n<li>Selecting the relevant report<\/li>\n<li>Choose your options and click <strong>Generate Report<\/strong><\/li>\n<li>Once the report has been created, click the <strong>Microsoft Excel Icon<\/strong> ( <img class=\"lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/excelicon.gif\" alt=\"Microsoft Excel Icon\" \/>\u00a0)<\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27807\" title=\"Okappy Export Data Microsoft Excel\" src=\"https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel-1024x710.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel-1024x710.png\" alt=\"Okappy Export Data Microsoft Excel\" width=\"1024\" height=\"710\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27710%27%20viewBox%3D%270%200%201024%20710%27%3E%3Crect%20width%3D%271024%27%20height%3D%273710%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel-200x139.png 200w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel-300x208.png 300w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel-400x277.png 400w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel-600x416.png 600w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel-768x533.png 768w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel-800x555.png 800w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel-1024x710.png 1024w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel-1200x832.png 1200w, https:\/\/okappyimages.okappy.com\/Okappy-Export-Data-Microsoft-Excel.png 1312w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>Click the <strong>Copy formula<\/strong> button<\/li>\n<li>The formula will be copied<\/li>\n<\/ul>\n<\/div><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-4 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"margin-top:0px;margin-bottom:31px;\"><h1 class=\"title-heading-left\" style=\"margin:0;\">3) Link Your Microsoft Excel spreadsheet to Okappy<\/h1><\/div><div class=\"fusion-text fusion-text-4\" style=\"transform:translate3d(0,0,0);\"><p>From within Microsoft Excel,<\/p>\n<ul>\n<li>Click <strong>Data<\/strong> in the toolbar<\/li>\n<li>Click <strong>From Web<\/strong> in the <strong>Get Data<\/strong> section<\/li>\n<li>Right click on the URL field and paste the URL you copied from Okappy into the <strong>URL<\/strong> field<\/li>\n<li><strong>Note<\/strong>: If there is nothing to paste, go back to Okappy and repeat the steps to generate your report data formula<\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27788\" title=\"Microsoft Excel Add URL Step1\" src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1-1024x576.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1-1024x576.png\" alt=\"Microsoft Excel Add URL Step1\" width=\"1024\" height=\"576\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27576%27%20viewBox%3D%270%200%201024%20576%27%3E%3Crect%20width%3D%271024%27%20height%3D%273576%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1-200x113.png 200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1-300x169.png 300w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1-400x225.png 400w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1-600x338.png 600w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1-768x432.png 768w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1-800x450.png 800w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1-1024x576.png 1024w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1-1200x675.png 1200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step1.png 1920w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>In the next screen, click <strong>Connect<\/strong><\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27789\" title=\"Microsoft Excel Add URL Step2\" src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2-1024x576.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2-1024x576.png\" alt=\"Microsoft Excel Add URL Step2\" width=\"1024\" height=\"576\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27576%27%20viewBox%3D%270%200%201024%20576%27%3E%3Crect%20width%3D%271024%27%20height%3D%273576%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2-200x113.png 200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2-300x169.png 300w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2-400x225.png 400w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2-600x338.png 600w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2-768x432.png 768w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2-800x450.png 800w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2-1024x576.png 1024w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2-1200x675.png 1200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step2.png 1920w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>If Microsoft Excel cannot determine the file type, then the following screen will be shown instead of the screen above<\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27810\" title=\"Microsoft Excel Convert Data\" src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data-1024x576.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data-1024x576.png\" alt=\"Microsoft Excel Convert Data\" width=\"1024\" height=\"576\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27576%27%20viewBox%3D%270%200%201024%20576%27%3E%3Crect%20width%3D%271024%27%20height%3D%273576%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data-200x113.png 200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data-300x169.png 300w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data-400x225.png 400w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data-600x338.png 600w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data-768x432.png 768w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data-800x450.png 800w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data-1024x576.png 1024w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data-1200x675.png 1200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Convert-Data.png 1920w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>Click <strong>Open As<\/strong><\/li>\n<li>Select <strong>Csv document<\/strong><\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27809\" title=\"Excel Open As CSV\" src=\"https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV-1024x576.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV-1024x576.png\" alt=\"Excel Open As CSV\" width=\"1024\" height=\"576\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27576%27%20viewBox%3D%270%200%201024%20576%27%3E%3Crect%20width%3D%271024%27%20height%3D%273576%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV-200x113.png 200w, https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV-300x169.png 300w, https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV-400x225.png 400w, https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV-600x338.png 600w, https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV-768x432.png 768w, https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV-800x450.png 800w, https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV-1024x576.png 1024w, https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV-1200x675.png 1200w, https:\/\/okappyimages.okappy.com\/Excel-Open-As-CSV.png 1920w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>The data will be displayed in the <strong>Power Query Editor<\/strong> window<\/li>\n<li>Click <strong>Close &amp; Load<\/strong><\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27790\" title=\"Microsoft Excel Add URL Step3\" src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3-1024x576.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3-1024x576.png\" alt=\"Microsoft Excel Add URL Step3\" width=\"1024\" height=\"576\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27576%27%20viewBox%3D%270%200%201024%20576%27%3E%3Crect%20width%3D%271024%27%20height%3D%273576%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3-200x113.png 200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3-300x169.png 300w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3-400x225.png 400w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3-600x338.png 600w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3-768x432.png 768w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3-800x450.png 800w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3-1024x576.png 1024w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3-1200x675.png 1200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step3.png 1920w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>The data will be created in a new sheet<\/li>\n<li>You can click the <strong>Refresh icon<\/strong> any time to refresh the data<\/li>\n<li>Alternatively, hover over the query to get more options<\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27813\" title=\"Microsoft Excel Refresh Data\" src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data-1024x576.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data-1024x576.png\" alt=\"Microsoft Excel Refresh Data\" width=\"1024\" height=\"576\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27576%27%20viewBox%3D%270%200%201024%20576%27%3E%3Crect%20width%3D%271024%27%20height%3D%273576%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data-200x113.png 200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data-300x169.png 300w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data-400x225.png 400w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data-600x338.png 600w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data-768x432.png 768w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data-800x450.png 800w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data-1024x576.png 1024w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data-1200x675.png 1200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Refresh-Data.png 1920w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>To change options, click the three dots at the bottom of the window<\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27792\" title=\"Microsoft Excel Add URL Step5\" src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5-1024x576.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5-1024x576.png\" alt=\"Microsoft Excel Add URL Step5\" width=\"1024\" height=\"576\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27576%27%20viewBox%3D%270%200%201024%20576%27%3E%3Crect%20width%3D%271024%27%20height%3D%273576%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5-200x113.png 200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5-300x169.png 300w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5-400x225.png 400w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5-600x338.png 600w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5-768x432.png 768w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5-800x450.png 800w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5-1024x576.png 1024w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5-1200x675.png 1200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step5.png 1920w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>Select <strong>Properties<\/strong><\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27793\" title=\"Microsoft Excel Add URL Step6\" src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6-1024x576.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6-1024x576.png\" alt=\"Microsoft Excel Add URL Step6\" width=\"1024\" height=\"576\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27576%27%20viewBox%3D%270%200%201024%20576%27%3E%3Crect%20width%3D%271024%27%20height%3D%273576%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6-200x113.png 200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6-300x169.png 300w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6-400x225.png 400w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6-600x338.png 600w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6-768x432.png 768w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6-800x450.png 800w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6-1024x576.png 1024w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6-1200x675.png 1200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step6.png 1920w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<ul>\n<li>Various options are available including how often Microsoft Excel will refresh the data<\/li>\n<\/ul>\n<p><img class=\"lazyload size-large wp-image-27794\" title=\"Microsoft Excel Add URL Step7\" src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7-1024x576.png\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7-1024x576.png\" alt=\"Microsoft Excel Add URL Step7\" width=\"1024\" height=\"576\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%271024%27%20height%3D%27576%27%20viewBox%3D%270%200%201024%20576%27%3E%3Crect%20width%3D%271024%27%20height%3D%273576%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-srcset=\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7-200x113.png 200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7-300x169.png 300w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7-400x225.png 400w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7-600x338.png 600w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7-768x432.png 768w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7-800x450.png 800w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7-1024x576.png 1024w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7-1200x675.png 1200w, https:\/\/okappyimages.okappy.com\/Microsoft-Excel-Add-URL-Step7.png 1920w\" data-sizes=\"auto\" data-orig-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><strong>Notes:<\/strong><\/p>\n<ul>\n<li>Do not set the refresh period to often as this could slow down the performance on your account.<\/li>\n<li>Okappy reserves the right to limit the number of requests if required.<\/li>\n<\/ul>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Find out how to dynamically pull information from Okappy into Microsoft Excel and generate management information<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"spay_email":""},"portfolio_category":[],"portfolio_skills":[],"portfolio_tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v16.6.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Dynamically linking data between Okappy and Microsoft Excel - Okappy<\/title>\n<meta name=\"description\" content=\"Find out how to dynamically pull information from Okappy into Microsoft Excel where you can manipulate the data and generate management information.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dynamically linking data between Okappy and Microsoft Excel - Okappy\" \/>\n<meta property=\"og:description\" content=\"Find out how to dynamically pull information from Okappy into Microsoft Excel where you can manipulate the data and generate management information.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Okappy\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T06:31:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.okappy.com\/images\/Microsoft-Excel-1024x576.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.okappy.com\/#organization\",\"name\":\"Okappy Limited\",\"url\":\"https:\/\/www.okappy.com\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.okappy.com\/#logo\",\"inLanguage\":\"en-GB\",\"url\":\"https:\/\/okappyimages.okappy.com\/images\/20171223135158\/okappy-logo%402x-e1547078327884.png\",\"contentUrl\":\"https:\/\/okappyimages.okappy.com\/images\/20171223135158\/okappy-logo%402x-e1547078327884.png\",\"width\":452,\"height\":210,\"caption\":\"Okappy Limited\"},\"image\":{\"@id\":\"https:\/\/www.okappy.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.okappy.com\/#website\",\"url\":\"https:\/\/www.okappy.com\/\",\"name\":\"Okappy\",\"description\":\"Rethinking workforce management\",\"publisher\":{\"@id\":\"https:\/\/www.okappy.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.okappy.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-microsoft-excel\/#primaryimage\",\"inLanguage\":\"en-GB\",\"url\":\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-1024x576.png\",\"contentUrl\":\"https:\/\/okappyimages.okappy.com\/Microsoft-Excel-1024x576.png\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-microsoft-excel\/#webpage\",\"url\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-microsoft-excel\/\",\"name\":\"Dynamically linking data between Okappy and Microsoft Excel - Okappy\",\"isPartOf\":{\"@id\":\"https:\/\/www.okappy.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-microsoft-excel\/#primaryimage\"},\"datePublished\":\"2019-09-12T09:15:10+00:00\",\"dateModified\":\"2019-09-13T06:31:04+00:00\",\"description\":\"Find out how to dynamically pull information from Okappy into Microsoft Excel where you can manipulate the data and generate management information.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-microsoft-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-microsoft-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.okappy.com\/support-article\/dynamically-linking-data-between-okappy-microsoft-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.okappy.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Portfolio\",\"item\":\"https:\/\/www.okappy.com\/support-article\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Dynamically linking data between Okappy and Microsoft Excel\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/avada_portfolio\/27785"}],"collection":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/avada_portfolio"}],"about":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/types\/avada_portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/comments?post=27785"}],"version-history":[{"count":0,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/avada_portfolio\/27785\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/media?parent=27785"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/portfolio_category?post=27785"},{"taxonomy":"portfolio_skills","embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/portfolio_skills?post=27785"},{"taxonomy":"portfolio_tags","embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/portfolio_tags?post=27785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}