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.

There is a "Print" option in the context menu in Windows, you don't need to open a document in the program with the file association first. This works with documents, but obviously not in file ...