Why Use Structured References? Excel is well known as a program that allows you to create complex tables of data.

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

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.

Show users how to create a quick table of contents in Excel using the power of hyperlinks. Hyperlinks have been around for a long time, but some Excel users just don’t use them.