I know it’s a relatively old comment but there’s never a bad time for this. I wasted a couple hours last week hunting an error in my code, only to realise my agency-side colleague hadn’t updated the rows reference for a bunch of pivot tables built off my output. A couple years ago I started forcing myself to always make table before pivot, even if I don’t think I will reuse the file down the line.
I know it’s a relatively old comment but there’s never a bad time for this. I wasted a couple hours last week hunting an error in my code, only to realise my agency-side colleague hadn’t updated the rows reference for a bunch of pivot tables built off my output. A couple years ago I started forcing myself to always make table before pivot, even if I don’t think I will reuse the file down the line.