{"id":4630,"date":"2023-07-09T12:06:26","date_gmt":"2023-07-09T12:06:26","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/"},"modified":"2023-07-09T12:06:26","modified_gmt":"2023-07-09T12:06:26","slug":"excel-pivot-tablo-adi-alani-gecerli-degil","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/","title":{"rendered":"Excel nas\u0131l onar\u0131l\u0131r: \u00f6zet tablo ad\u0131 alan\u0131 ge\u00e7ersiz"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Bazen Excel&#8217;de pivot tablo olu\u015fturmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda a\u015fa\u011f\u0131daki hatayla kar\u015f\u0131la\u015fabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>The PivotTable field name is not valid.\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Bu hata genellikle bir pivot tablo olu\u015fturmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda ancak kulland\u0131\u011f\u0131n\u0131z veri kayna\u011f\u0131ndaki s\u00fctunlardan birinin ba\u015fl\u0131\u011f\u0131 olmad\u0131\u011f\u0131nda ortaya \u00e7\u0131kar.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu hatay\u0131 \u00e7\u00f6zmek i\u00e7in, ba\u015fl\u0131klar\u0131 eksik olan s\u00fctunlara bir ba\u015fl\u0131k ad\u0131 eklemeniz yeterlidir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnekte bu hatan\u0131n pratikte nas\u0131l \u00e7\u00f6z\u00fclece\u011fi g\u00f6sterilmektedir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: \u00d6zet Tablo Ad\u0131 Alan\u0131n\u0131n Ge\u00e7ersiz Olmas\u0131 Nas\u0131l D\u00fczeltilir<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Diyelim ki Excel&#8217;de \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgiler i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahibiz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36117 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-du-champ2.png\" alt=\"\" width=\"463\" height=\"433\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u0130lk s\u00fctunun her oyuncunun tak\u0131m adlar\u0131n\u0131 i\u00e7erdi\u011fini ancak s\u00fctun ba\u015fl\u0131\u011f\u0131 bulunmad\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Diyelim ki bu veri k\u00fcmesini tak\u0131ma ve konuma g\u00f6re kazan\u0131lan puanlar\u0131 \u00f6zetleyen bir pivot tablo olu\u015fturmak i\u00e7in kullanmak istiyoruz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu pivot tabloyu olu\u015fturmak i\u00e7in <strong>A1:C11<\/strong> aral\u0131\u011f\u0131n\u0131 kullanmaya \u00e7al\u0131\u015f\u0131rsak bir hata mesaj\u0131 al\u0131r\u0131z:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-36118\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-champ1.png\" alt=\"Excel, pivot tablo ad\u0131 alan\u0131n\u0131n nas\u0131l d\u00fczeltilece\u011fi ge\u00e7ersiz\" width=\"658\" height=\"514\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>A1<\/strong> h\u00fccresinde ba\u015fl\u0131k olmad\u0131\u011f\u0131 i\u00e7in bu hata iletisini al\u0131yoruz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu hatay\u0131 \u00e7\u00f6zmek i\u00e7in basit\u00e7e bir ba\u015fl\u0131k ad\u0131 ekleyebiliriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36119 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-du-champ3.png\" alt=\"\" width=\"484\" height=\"418\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Art\u0131k pivot tablo olu\u015fturmak i\u00e7in <strong>A1:C11<\/strong> aral\u0131\u011f\u0131n\u0131 kulland\u0131\u011f\u0131m\u0131zda herhangi bir hata mesaj\u0131 almayaca\u011f\u0131z \u00e7\u00fcnk\u00fc kullanmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131z her s\u00fctunun art\u0131k bir ba\u015fl\u0131k ad\u0131 var.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pivot tabloyu hatas\u0131z bir \u015fekilde ba\u015far\u0131yla olu\u015fturabilece\u011fiz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36120 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-du-champ4.png\" alt=\"\" width=\"639\" height=\"419\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;deki di\u011fer yayg\u0131n hatalar\u0131n nas\u0131l d\u00fczeltilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/excel-adi-hatasi\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de #NAME Hatas\u0131 Nas\u0131l D\u00fczeltilir<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-deger-hatasini-yoksay\/\" target=\"_blank\" rel=\"noopener\">#DE\u011eER nas\u0131l g\u00f6z ard\u0131 edilir? Excel&#8217;de hata<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-eger-hata-bos\/\" target=\"_blank\" rel=\"noopener\">E\u011eERHATA nas\u0131l kullan\u0131l\u0131r ve ard\u0131ndan Excel&#8217;de bo\u015f b\u0131rak\u0131l\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bazen Excel&#8217;de pivot tablo olu\u015fturmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda a\u015fa\u011f\u0131daki hatayla kar\u015f\u0131la\u015fabilirsiniz: The PivotTable field name is not valid. Bu hata genellikle bir pivot tablo olu\u015fturmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda ancak kulland\u0131\u011f\u0131n\u0131z veri kayna\u011f\u0131ndaki s\u00fctunlardan birinin ba\u015fl\u0131\u011f\u0131 olmad\u0131\u011f\u0131nda ortaya \u00e7\u0131kar. Bu hatay\u0131 \u00e7\u00f6zmek i\u00e7in, ba\u015fl\u0131klar\u0131 eksik olan s\u00fctunlara bir ba\u015fl\u0131k ad\u0131 eklemeniz yeterlidir. A\u015fa\u011f\u0131daki \u00f6rnekte bu hatan\u0131n pratikte nas\u0131l \u00e7\u00f6z\u00fclece\u011fi g\u00f6sterilmektedir. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4630","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Nas\u0131l Onar\u0131l\u0131r: PivotTable Ad\u0131 Alan\u0131 Ge\u00e7ersiz - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde Excel&#039;de a\u015fa\u011f\u0131daki hatan\u0131n nas\u0131l d\u00fczeltilece\u011fi a\u00e7\u0131klanmaktad\u0131r: Pivot tablo ad\u0131 alan\u0131 ge\u00e7ersiz.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Nas\u0131l Onar\u0131l\u0131r: PivotTable Ad\u0131 Alan\u0131 Ge\u00e7ersiz - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde Excel&#039;de a\u015fa\u011f\u0131daki hatan\u0131n nas\u0131l d\u00fczeltilece\u011fi a\u00e7\u0131klanmaktad\u0131r: Pivot tablo ad\u0131 alan\u0131 ge\u00e7ersiz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T12:06:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-du-champ2.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/\",\"name\":\"Excel Nas\u0131l Onar\u0131l\u0131r: PivotTable Ad\u0131 Alan\u0131 Ge\u00e7ersiz - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-09T12:06:26+00:00\",\"dateModified\":\"2023-07-09T12:06:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde Excel&#39;de a\u015fa\u011f\u0131daki hatan\u0131n nas\u0131l d\u00fczeltilece\u011fi a\u00e7\u0131klanmaktad\u0131r: Pivot tablo ad\u0131 alan\u0131 ge\u00e7ersiz.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel nas\u0131l onar\u0131l\u0131r: \u00f6zet tablo ad\u0131 alan\u0131 ge\u00e7ersiz\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Nas\u0131l Onar\u0131l\u0131r: PivotTable Ad\u0131 Alan\u0131 Ge\u00e7ersiz - Statorials","description":"Bu e\u011fitimde Excel&#39;de a\u015fa\u011f\u0131daki hatan\u0131n nas\u0131l d\u00fczeltilece\u011fi a\u00e7\u0131klanmaktad\u0131r: Pivot tablo ad\u0131 alan\u0131 ge\u00e7ersiz.","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:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel Nas\u0131l Onar\u0131l\u0131r: PivotTable Ad\u0131 Alan\u0131 Ge\u00e7ersiz - Statorials","og_description":"Bu e\u011fitimde Excel&#39;de a\u015fa\u011f\u0131daki hatan\u0131n nas\u0131l d\u00fczeltilece\u011fi a\u00e7\u0131klanmaktad\u0131r: Pivot tablo ad\u0131 alan\u0131 ge\u00e7ersiz.","og_url":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/","og_site_name":"Statorials","article_published_time":"2023-07-09T12:06:26+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-du-champ2.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/","url":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/","name":"Excel Nas\u0131l Onar\u0131l\u0131r: PivotTable Ad\u0131 Alan\u0131 Ge\u00e7ersiz - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-09T12:06:26+00:00","dateModified":"2023-07-09T12:06:26+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde Excel&#39;de a\u015fa\u011f\u0131daki hatan\u0131n nas\u0131l d\u00fczeltilece\u011fi a\u00e7\u0131klanmaktad\u0131r: Pivot tablo ad\u0131 alan\u0131 ge\u00e7ersiz.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-adi-alani-gecerli-degil\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel nas\u0131l onar\u0131l\u0131r: \u00f6zet tablo ad\u0131 alan\u0131 ge\u00e7ersiz"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4630"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4630\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}