Excel Tip: Avoid Other People’s Mistakes
Is a shared workbook and its macros going to harm your computer? Here's how to handle other people's spreadsheets safely.
Referring to Other Worksheets or Workbooks in an Excel Macro
Move to a powerful stage in your Excel macro-building progression. Read here how to access information in another workbook with a macro that is part of a different workbook.
Spreadsheets: Filtering a Pivot Table with a Formula
There is really no good way to change the filter with a formula. However, there is a quick fix to remedy the situation.
Spreadsheets: Suppressing Cells in a Pivot Table
The trick in this week's article is using a Microsoft loophole for cells that add up to zero.