Using Structured References Within a Table To use structured references within your table, as in the example above, you first need to add some data to your Excel worksheet, with column names ...

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.

By default, references in Excel use the A1 reference style, which means that it refers to the column first, and then the row number. However, the INDIRECT function enables you to switch these around.

Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a spill range so you can use the hashtag shortcut.

If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.