{"id":5355,"date":"2020-12-14T13:18:11","date_gmt":"2020-12-14T13:18:11","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=5355"},"modified":"2024-03-29T15:55:39","modified_gmt":"2024-03-29T15:55:39","slug":"filter-excel-pivot-table-using-vba","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/","title":{"rendered":"How to Filter Excel Pivot Table using VBA"},"content":{"rendered":"\n

Excel offers a robust tool for filtering Pivot Tables with the VBA code. In this article, I’m going to show you different ways you can do it.<\/p>\n\n\n\n

Create a Pivot table in VBA<\/h2>\n\n\n\n

We have the following data:<\/p>\n\n\n\n

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

It’s a list of names with cities, states, and birth dates. I’m going to use this data to demonstrate filtering options.<\/p>\n\n\n\n

Make sure that the sheet with the data is active and run this code:<\/p>\n\n\n\n

Sub CreatePivotTable()    \n    Dim mySheet     As Worksheet\n    Dim myPivotCache As PivotCache\n    Dim myPivotTable As PivotTable\n    Dim myPivotTableStart As String\n    Dim myString    As String\n    \n    myString = ActiveSheet.Name & \"!\" & Range(\"A1:D11\").Address(ReferenceStyle:=xlR1C1)\n    \n    Set mySheet = Sheets.Add\n    \n    myPivotTableStart = mySheet.Name & \"!\" & mySheet.Range(\"A1\").Address(ReferenceStyle:=xlR1C1)\n    \n    Set myPivotCache = ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=myString)\n    \n    Set myPivotTable = myPivotCache.CreatePivotTable(TableDestination:=myPivotTableStart, TableName:=\"PivotTable1\")    \nEnd Sub<\/code><\/pre>\n\n\n\n
In the beginning, this subprocedure gets the data range for the pivot table (A1:E11<\/strong>).<\/p>\n\n\n\n
Next, it creates a new sheet with the default name.<\/p>\n\n\n\n
The myPivotTableStart<\/strong> variable determines where the Pivot Table starts. In this case, it’s cell A1<\/strong>.<\/p>\n\n\n\n
Next, we are going to create myPivotCache<\/strong> to hold the replica of the data source.<\/p>\n\n\n\n
At the end of the procedure, a pivot table name “PivotTable1” will be created from this cache.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Filtering Pivot Tables<\/h2>\n\n\n\n
It’s time to start filtering Pivot Table data. You can assign 5 different values to a field.<\/p>\n\n\n\n
Name<\/strong><\/td>Value<\/strong><\/td>Field<\/strong><\/td><\/tr>
xlHidden<\/td>0<\/td>No field<\/td><\/tr>
xRowField<\/td>1<\/td>Rows<\/td><\/tr>
xColumnField<\/td>2<\/td>Columns<\/td><\/tr>
xlPageField<\/td>3<\/td>Filters<\/td><\/tr>
xlDataField<\/td>4<\/td>Values<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
The following code inserts Pivot Table elements into fields:<\/p>\n\n\n\n
Sub AddPivotFields()\n    Set myPivotTable = ActiveSheet.PivotTables(\"PivotTable1\")\n    \n    myPivotTable.PivotFields(\"Name\").Orientation = xlRowField\n    myPivotTable.PivotFields(\"City\").Orientation = xlRowField\n    myPivotTable.PivotFields(\"City\").Position = 1\n    myPivotTable.PivotFields(\"State\").Orientation = xlPageField\n    myPivotTable.PivotFields(\"Birth\").Orientation = xlHiddenField\nEnd Sub<\/code><\/pre>\n\n\n\n
At the beginning of the code, there is a Pivot Table assignment to the myPivotTable<\/strong> variable.<\/p>\n\n\n\n
Two table headers (“Name” and “City”) are added to the Rows<\/strong> Field. Now, “City” is after “Name”, but it’s important to have “City” as the first position. The next line of code do just that.<\/p>\n\n\n\n
The “State” field is added as a Pivot Table filter.<\/p>\n\n\n\n
The last line before the end is xlHiddenField<\/strong>. It makes sure that the “Birth” header is not used in any field of the Pivot Table.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Clear filter<\/h2>\n\n\n\n
If you want to run the code multiple times, you may want to clear the Pivot Table before doing that. This code will help you with that.<\/p>\n\n\n\n
Add it just after assigning a Pivot Table to a variable:<\/p>\n\n\n\n
Set myPivotTable = ActiveSheet.PivotTables(\"PivotTable1\")\nmyPivotTable.ClearTable<\/code><\/pre>\n\n\n\n
You can also create a sub procedure to do that:<\/p>\n\n\n\n
Sub ClearPivotTable()\n    ActiveSheet.PivotTables(\"PivotTable1\").ClearTable\nEnd Sub<\/code><\/pre>\n\n\n\n
Filter based on variable<\/h2>\n\n\n\n
Each person lives in a city that is located inside a state. There are codes of three states: New York, California, and Arizona. Instead of displaying all the values, display only one based on a variable:<\/p>\n\n\n\n
Add Pivot Table fields again, ad run the following code.<\/p>\n\n\n\n
Sub FilterBasedOnVariable()\n    Dim myPivotField As PivotField\n    Dim filterValue As String\n    \n    Set myPivotField = ActiveSheet.PivotTables(\"PivotTable1\").PivotFields(\"State\")\n    filterValue = \"NY\"\n    \n    myPivotField.CurrentPage = filterValue\nEnd Sub<\/code><\/pre>\n\n\n\n
This code will restrict the filter to display only people and cities that are located in the state of New York.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Filter based on cell value<\/h2>\n\n\n\n
You can also use cell value<\/a> instead of a variable. You have to add a filter value inside a cell. I added one next to the table.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Change the filterValue<\/strong> variable. This is what the code looks like:<\/p>\n\n\n\n
Sub FilterBasedOnCellValue()\n    Dim myPivotField As PivotField\n    Dim filterValue As String\n    \n    Set myPivotField = ActiveSheet.PivotTables(\"PivotTable1\").PivotFields(\"State\")\n    filterValue = ActiveWorkbook.Sheets(\"Sheet1\").Range(\"F2\").Value\n    \n    myPivotField.CurrentPage = filterValue\nEnd Sub<\/code><\/pre>\n\n\n\n
Now, instead of New York, we have filters or California.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Filter on multiple items<\/h2>\n\n\n\n
You can also filter data using multiple values<\/a>. You can use arrays or ranges.<\/p>\n\n\n\n
Based on array<\/h3>\n\n\n\n
Code becomes more complicated when we start to deal with multiple elements. It wouldn’t be a problem if we just could set visibility to all elements to False<\/strong> and then add True<\/strong> to ones from an array. The problem is, if you try to set all visible elements to False<\/strong>, Excel will return an error.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
We have to do it using a different approach. First, let’s run the code.<\/p>\n\n\n\n
Sub FilterMultipleArray()\n    FilterArray = Array(\"AZ\", \"NY\")\n    \n    Dim myPivotField As PivotField\n    Set myPivotField = ActiveSheet.PivotTables(\"PivotTable1\").PivotFields(\"State\")\n    myPivotField.ClearAllFilters\n    myPivotField.EnableMultiplePageItems = TRUE\n    \n    numberOfElements = UBound(FilterArray) - LBound(FilterArray) + 1\n    \n    If numberOfElements > 0 Then\n        With myPivotField\n            For i = 1 To myPivotField.PivotItems.Count\n                j = 0\n                Do While j < numberOfElements\n                    If myPivotField.PivotItems(i).Name = FilterArray(j) Then\n                        myPivotField.PivotItems(myPivotField.PivotItems(i).Name).Visible = TRUE\n                        Exit Do\n                    Else\n                        myPivotField.PivotItems(myPivotField.PivotItems(i).Name).Visible = FALSE\n                    End If\n                    j = j + 1\n                Loop\n            Next i\n        End With\n    End If\nEnd Sub<\/code><\/pre>\n\n\n\n
At the beginning of the code, we have to clear all filters<\/a> and enable the ability to choose multiple page items.<\/p>\n\n\n\n
Now, we are using UBound<\/strong> and LBound<\/strong> functions to determine the number of elements inside the FilterArray<\/strong> array.<\/p>\n\n\n\n
Having this number, we can use the If<\/strong> clause and run it only if there is at least one element inside the array (numberOfElements > 0<\/strong>). This assures us that there is at least one element, otherwise, it would set all values to false and therefore return an error.<\/p>\n\n\n\n
Later in the code, there are two loops: For<\/strong> and Do While<\/strong>.<\/p>\n\n\n\n
They are used to check each item in the filter (AZ, NY, CA)  with items inside the array (AZ, NY).<\/p>\n\n\n\n
If both values match, the code makes the pivot item visible and exits the loop (Exit Do<\/strong>) because we know that this value exists. If we didn’t exit the loop, the pivot item would be overridden by the next item in the array and the visibility would be set to False<\/strong>.<\/p>\n\n\n\n
This is the result of the code:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
As you can see, the Select Multiple Items<\/strong> checkbox is selected, and both values (and only them) from the table are checked (Visible = True<\/strong>). Values that are not in the list are unchecked (Visible = False<\/strong>).<\/p>\n\n\n\n
Based on the range<\/h3>\n\n\n\n
There is a way to use a range of cells as a source for filter items. Just be sure that these items are in one column, and that there are no empty cells<\/a> anywhere.<\/p>\n\n\n\n
To illustrate how it works, add one more position to the filter on “Sheet1”.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Now, you have to switch this code in “FilterMultipleArray”:<\/p>\n\n\n\n
FilterArray = Array(\"AZ\", \"NY\")<\/code><\/pre>\n\n\n\n
To this one:<\/p>\n\n\n\n
FilterArray = Application.Transpose(ActiveWorkbook.Sheets(\"Sheet1\").Range(\"F2:F3\").Value)<\/code><\/pre>\n\n\n\n
Transposing this range converts a 2d array to a 1d array.<\/p>\n\n\n\n
The rest of the code should stay the same.<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel offers a robust tool for filtering Pivot Tables with the VBA code. In this article, I’m going to show you different ways…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[190],"yoast_head":"\nHow to Filter Excel Pivot Table using VBA<\/title>\n<meta name=\"description\" content=\"Learn how to filter Pivot Tables with VBA code. This article shows different ways to filter data using Excel's powerful tool. Create Pivot Tables in VBA and manage your data effectively.\" \/>\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\/vba\/filter-excel-pivot-table-using-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Filter Excel Pivot Table using VBA\" \/>\n<meta property=\"og:description\" content=\"Learn how to filter Pivot Tables with VBA code. This article shows different ways to filter data using Excel's powerful tool. Create Pivot Tables in VBA and manage your data effectively.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-14T13:18:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-29T15:55:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/12\/example-data.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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"How to Filter Excel Pivot Table using VBA\",\"datePublished\":\"2020-12-14T13:18:11+00:00\",\"dateModified\":\"2024-03-29T15:55:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/\"},\"wordCount\":851,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/12\/example-data.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"vba\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/\",\"url\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/\",\"name\":\"How to Filter Excel Pivot Table using VBA\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/12\/example-data.png\",\"datePublished\":\"2020-12-14T13:18:11+00:00\",\"dateModified\":\"2024-03-29T15:55:39+00:00\",\"description\":\"Learn how to filter Pivot Tables with VBA code. This article shows different ways to filter data using Excel's powerful tool. Create Pivot Tables in VBA and manage your data effectively.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/12\/example-data.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/12\/example-data.png\",\"width\":422,\"height\":262},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Filter Excel Pivot Table using VBA\"}]},{\"@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":"How to Filter Excel Pivot Table using VBA","description":"Learn how to filter Pivot Tables with VBA code. This article shows different ways to filter data using Excel's powerful tool. Create Pivot Tables in VBA and manage your data effectively.","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\/vba\/filter-excel-pivot-table-using-vba\/","og_locale":"en_US","og_type":"article","og_title":"How to Filter Excel Pivot Table using VBA","og_description":"Learn how to filter Pivot Tables with VBA code. This article shows different ways to filter data using Excel's powerful tool. Create Pivot Tables in VBA and manage your data effectively.","og_url":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/","article_published_time":"2020-12-14T13:18:11+00:00","article_modified_time":"2024-03-29T15:55:39+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/12\/example-data.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"How to Filter Excel Pivot Table using VBA","datePublished":"2020-12-14T13:18:11+00:00","dateModified":"2024-03-29T15:55:39+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/"},"wordCount":851,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/12\/example-data.png","keywords":["pinterest"],"articleSection":["vba"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/","url":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/","name":"How to Filter Excel Pivot Table using VBA","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/12\/example-data.png","datePublished":"2020-12-14T13:18:11+00:00","dateModified":"2024-03-29T15:55:39+00:00","description":"Learn how to filter Pivot Tables with VBA code. This article shows different ways to filter data using Excel's powerful tool. Create Pivot Tables in VBA and manage your data effectively.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/12\/example-data.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2020\/12\/example-data.png","width":422,"height":262},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/vba\/filter-excel-pivot-table-using-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"How to Filter Excel Pivot Table using VBA"}]},{"@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\/5355"}],"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=5355"}],"version-history":[{"count":14,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/5355\/revisions"}],"predecessor-version":[{"id":12914,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/5355\/revisions\/12914"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=5355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=5355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=5355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}