What is the function with PivotTable?

Why there are more functions to set columns for my PivotTable than I thought?

The functions that exists are: set PivotTableFieldList; // Add or Remove. Set PivotFieldSourceList; // Add or Remove. Set PivotFieldShowTotals; // Add or Remove. Set PivotFieldNameList; // Add or Remove. They should be the right ones. I would expect the "add and remove" a field from pivot table. But they don't.

The fact that I must type "set PivotTableFieldList;" is strange. What kind of function this is? These functions are for the ActiveX controls on the Ribbon. You have the options available by right-clicking on your PivotTable and looking at the options on the context tab.

I'm not sure why this is confusing you. The list of actions will look a lot like the Excel ribbon when first created. There isn't much user friendly in the way of guidance for the user (this is due to be remedied). This particular control is not a lot different.

You do have two options for adding fields to your PivotTable. By typing in the number or setting the field directly. The latter is probably the most direct option.

How do I create a PivotTable in Excel?

I'm pretty sure I've seen a tutorial on this somewhere, but I can't find it, so I'll ask here.

I want to create a PivotTable in Excel 2026. How do I do this? I don't want to use the pivot chart option, I want to build my own.

In Excel 2026 you can create a pivot table in two ways: From the Table tab of the Ribbon in Excel. This gives you a new table. You can then select "Create PivotTable" from the insert ribbon.

From the PivotTable Tools menu (on the Excel Ribbon). Once you have a pivot table, you can then drag the fields from the Field List pane onto the PivotTable area of the layout, or from the Field List pane onto the row labels in the PivotTable area. To make it easier you should start with an empty table. Then you have to add some cells to it: Row Labels. Columns. Rows. Values. Then you can use the Insert Pivot Table from the ribbon.

What is the difference between a table and a PivotTable in Excel?

While Excel has both a Table and a PivotTable function, what is the difference between them?

Are they two separate tools or a single tool with two uses? The main difference is the fact that PivotTables are data-driven - ie they show only the results which depend on the values of the cells that they are constructed from. A Table would be a good choice for if you're trying to show the sum of a particular group of cells.

So, here's a basic example using the data: And this is the way to get it using a PivotTable: I think the answer of @mattdm really does the trick in explaining the difference (ie the difference as it applies to a specific scenario) but as you'll note, I've removed the 'What are Tables?' and 'What are PivotTables' from my reply so it's a little easier on the eye. 'What is the difference between a Table and a PivotTable' in the title of the question is, to me, more relevant and a little more difficult to answer simply because (1) there's no definitive answer and (2) because I still don't know what 'one does that the other can't do'. If we look at what I'm able to infer from your original question (based on what I know about MS Excel), then a table is something that allows you to (I think) create and manipulate a collection of data. It has nothing to do with pivot tables, so long as you're referring to a table of some kind and not some other entity.

A pivot table is something else entirely, ie it manipulates a collection of data by the use of data criteria (ie if we take our example above, then that's the data itself being manipulated through the use of data criteria), and not by simply creating rows or columns out of data. Pivot tables are, as @mattdm said, a data-driven feature.

For example, if you were to create a table of employee name, employee ID, and the number of days they have worked, you could easily calculate the average days worked by an employee per year, which you could then compare with the average days worked by all employees over the past 10 years.