GetPivotData Empty Strings and Data Fields
Catchy title I think you’ll agree - GETPIVOTDATA click bait if ever I saw it…
tips
A collection of 6 posts
Macro to wrap IFERROR() around formula in cell or range
This is a fantastic little macro that I picked up from The Spreadsheet Guru
Using Custom Cell Styles
How many times have you had to set up a custom format to show a negative cell value in red font with brackets?
How to Break Resistant External Links in Excel
Usually when you want to break or amend a link in Excel you use the Edit Links feature under the data ribbon. You can either re-point the link or choose to break it, at which point the last updated values are...
Pasting Formulas without Changing Cell References
This tip enables you to make an exact copy of a range of formulas without changing cell references or links to other workbooks.