Pivot tables in Google Sheets has this annoying "feature" that even if you use dynamic range in your data source (e.g. A:D), it will immediately replace it with the maximum range available at that ...