When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference.
To turn this feature off, follow the instructions in this short video.
For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables.
________________
In Excel 2003, if there are duplicate items in a list, you can delete them by using an Advanced Filter. To remove the duplicates, follow the steps in this short Excel video tutorial. ______________
Bill Jelen is the the king of all Excel media! In addition to his MrExcel website, and his book publishing empire, and his Excel podcasts, Bill has been on YouTube since July 23, 2006 – almost 15 years ago! Let’s take a look at it.
If you copy data from another program to Excel, Excel might treat the numbers as text, and totals that use these numbers will be incorrect. This video shows the simple steps to change the text "numbers" to real numbers. For written instructions, visit Convert Text to Numbers ______________________
If you get pivot table refresh errors, this video shows how to troubleshoot those errors and try to fix them. For example, one common error is, “The PivotTable field name is not valid”. Or, you might see this error: “PivotTable report cannot overlap another PivotTable report.”
Use the Excel IF function when you want to test something. The IF formula will show one result if the test result is True, and a different result if the test result is False. For example: Check if cell D7 is empty. If it is, the result is an empty string. If not, multiply C7…
In Excel 2003, or earlier versions, you can move the color and border palettes close to the cells you’re formatting. To see the steps, watch this short Excel video tutorial. For written instructions, see the move the color and border palettes in Excel notes on the Contextures website. ______