{"id":4875,"date":"2019-11-11T16:00:53","date_gmt":"2019-11-11T16:00:53","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=4875"},"modified":"2024-03-28T11:19:42","modified_gmt":"2024-03-28T11:19:42","slug":"link-one-excel-sheet-to-another","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/","title":{"rendered":"Link One Excel Sheet to Another"},"content":{"rendered":"\n
Link-One-Excel-Sheet-to-Another<\/a>Download File<\/a><\/div>\n\n\n\n

If you want to have the same data on one sheet as you have\non another, the simplest way to do it is to copy and paste those values. But if\nyou change data in one sheet, you will also have to change it to another one.<\/p>\n\n\n\n

There’s a better way to do it. You can use a reference to a cell\non another worksheet, so if those cells change, cells on our worksheet also\nchange.<\/p>\n\n\n\n

Let’s create a new sheet in the same workbook and name it “Names”<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Link a single cell<\/h2>\n\n\n\n

You can make a reference to each cell in the “Names”<\/strong> worksheet. Let’s make it to cell A2<\/strong>.<\/p>\n\n\n\n

=Names!$A$2<\/code><\/pre>\n\n\n\n

This formula makes an absolute cell reference<\/a>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now, if you try to AutoFill<\/a> the rest of the cells, of course, you will get the same name in other cells. That’s why you can use a relative reference to this cell and then use AutoFill<\/a>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Copy as a link<\/h2>\n\n\n\n

If you want to copy cells quickly, without typing a worksheet\nname, which is especially useful, if your sheets have long names.<\/p>\n\n\n\n

You can also copy multiple cells<\/a> as a link.<\/p>\n\n\n\n

This is what you have to do.<\/p>\n\n\n\n

Select cells from A1<\/strong>\nto A5<\/strong> and copy these cells (Ctrl + C<\/strong>).<\/p>\n\n\n\n

Right-click cell A1<\/strong>\nin the current sheet and choose Paste\nLink (N)<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The copied links are relative.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now, the values are linked to the “Names”<\/strong> sheet, but the formatting is not copied, you can\nuse the right-click one more time and this time paste Formatting (R)<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Link from the different workbook<\/h2>\n\n\n\n

You can also create a link to a worksheet in another workbook.<\/p>\n\n\n\n

Create a new XLSX file called “people.xlsx”<\/strong> in the same directory. Name one sheet “FirstNames”<\/strong>, and the other\none “LastNames”<\/strong>.<\/p>\n\n\n\n

FirstNames<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

LastNames<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Copy these to the current sheet, so it looks like this.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Take a look at the formula linking to these cells.<\/p>\n\n\n\n

=[people.xlsx]FirstNames!A2<\/code><\/pre>\n\n\n\n

There is a file name, worksheet name, and cell reference.<\/p>\n\n\n\n

If you close the “people.xlsx”<\/strong> file, the reference will change to the absolute path.<\/p>\n\n\n\n

='C:\\Excel\\[people.xlsx]FirstNames'!A2<\/code><\/pre>\n\n\n\n

Automatic and manual calculation options<\/h2>\n\n\n\n

You can set it Excel, whether you want manual or automatic\ncalculations.<\/p>\n\n\n\n

This option can be found in Formulas >> Calculation >> Calculation Options<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

By default, this option is set to automatic. If you change\nto manual, the results will not be updated, unless you do one of the following:<\/p>\n\n\n\n

    \n
  • Execute the formula for the cell you want to\nupdate.<\/li>\n\n\n\n
  • Click Calculate\nNow<\/strong> or Calculate Sheet<\/strong>, next to\nthe Calculation Options<\/strong> button.<\/li>\n\n\n\n
  • Press the F9<\/strong>\nkey.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

    If you want to have the same data on one sheet as you have on another, the simplest way to do it is…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nLink One Excel Sheet to Another<\/title>\n<meta name=\"description\" content=\"Learn how to link cells between two Excel sheets with absolute cell references. Keep data updated in multiple sheets with ease. Download the file.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Link One Excel Sheet to Another\" \/>\n<meta property=\"og:description\" content=\"Learn how to link cells between two Excel sheets with absolute cell references. Keep data updated in multiple sheets with ease. Download the file.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-11T16:00:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T11:19:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/11\/example.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Link One Excel Sheet to Another\",\"datePublished\":\"2019-11-11T16:00:53+00:00\",\"dateModified\":\"2024-03-28T11:19:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/\"},\"wordCount\":437,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/11\/example.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/\",\"name\":\"Link One Excel Sheet to Another\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/11\/example.png\",\"datePublished\":\"2019-11-11T16:00:53+00:00\",\"dateModified\":\"2024-03-28T11:19:42+00:00\",\"description\":\"Learn how to link cells between two Excel sheets with absolute cell references. Keep data updated in multiple sheets with ease. Download the file.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/11\/example.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/11\/example.png\",\"width\":164,\"height\":160},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Link One Excel Sheet to Another\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Link One Excel Sheet to Another","description":"Learn how to link cells between two Excel sheets with absolute cell references. Keep data updated in multiple sheets with ease. Download the file.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/","og_locale":"en_US","og_type":"article","og_title":"Link One Excel Sheet to Another","og_description":"Learn how to link cells between two Excel sheets with absolute cell references. Keep data updated in multiple sheets with ease. Download the file.","og_url":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/","article_published_time":"2019-11-11T16:00:53+00:00","article_modified_time":"2024-03-28T11:19:42+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/11\/example.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Link One Excel Sheet to Another","datePublished":"2019-11-11T16:00:53+00:00","dateModified":"2024-03-28T11:19:42+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/"},"wordCount":437,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/11\/example.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/","url":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/","name":"Link One Excel Sheet to Another","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/11\/example.png","datePublished":"2019-11-11T16:00:53+00:00","dateModified":"2024-03-28T11:19:42+00:00","description":"Learn how to link cells between two Excel sheets with absolute cell references. Keep data updated in multiple sheets with ease. Download the file.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/11\/example.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/11\/example.png","width":164,"height":160},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/link-one-excel-sheet-to-another\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Link One Excel Sheet to Another"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/4875"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=4875"}],"version-history":[{"count":7,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/4875\/revisions"}],"predecessor-version":[{"id":14212,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/4875\/revisions\/14212"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=4875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=4875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=4875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}