{"id":159,"date":"2009-10-24T14:15:29","date_gmt":"2009-10-24T18:15:29","guid":{"rendered":"http:\/\/exceltheatre.com\/blog\/archives\/2009\/10\/24\/stop-getpivotdata-formula-when-linking-to-pivot-table\/"},"modified":"2024-11-19T14:18:11","modified_gmt":"2024-11-19T19:18:11","slug":"stop-getpivotdata-formula-when-linking-to-pivot-table","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2009\/10\/24\/stop-getpivotdata-formula-when-linking-to-pivot-table\/","title":{"rendered":"Stop GetPivotData Formula When Linking to Pivot Table"},"content":{"rendered":"<p>When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference. <\/p>\n<p>To turn this feature off, follow the instructions in this short video.<\/p>\n<p>For written instructions, please see <a href=\"http:\/\/www.contextures.com\/xlPivot06.html\">Turn Off GetPivotData Formulas for Excel Pivot Tables<\/a>.<\/p>\n<p><iframe loading=\"lazy\" title=\"Turn Off GetPivotData Formulas for Excel PivotTables\" width=\"840\" height=\"630\" src=\"https:\/\/www.youtube.com\/embed\/_2wCgZWppXo?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p> ________________ <\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference. To turn this feature off, follow the instructions in this short video. For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables. ________________<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-159","post","type-post","status-publish","format-standard","hentry","category-excel-videos"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=159"}],"version-history":[{"count":2,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/159\/revisions"}],"predecessor-version":[{"id":4575,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/159\/revisions\/4575"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}