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.

Dormant data sources? These are data sources that an Excel workbook accesses but no longer uses the data. Inactive workbooks, worksheets, reports and charts?

A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of ...

Before you ditch Excel in favor of an alternative, make sure to implement a few strategic techniques to handle such large datasets easily and unlock their true potential in no time.

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.

So now when I download data into Excel, I make an entry, usually on Row 1, of my data source’s URL. It would be good to add the date accessed if you’re working on a school paper.