How do I find REF errors in Excel? Follow the steps below to find errors located in your Excel spreadsheet: Press Ctrl + F or click the Find and select button on the Home tab in the Editing group.

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.

Quick Fixes for “Retrieving Data. Wait a Few Seconds” in Microsoft Excel Wait for a Moment and Try Again: The most immediate and sensible fix would be to give Excel a second or two to breathe.