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.

If Microsoft Excel fails to recognize a file in the XLSX or XLS format, the data contained in the file could be corrupted. When you open a corrupted workbook in Excel, the program should ...

QUESTION:A while back, I installed a shareware program called 602 pc suite 2000. The program must have altered the way I log into Windows Explorer to read my Microsoft Excel files. When I do so, I ...