Forum Discussion
Liphor
Mar 04, 2021Brass Contributor
Flash fill not working when working with values from pivot tables
I am trying to flash fill my formula in column K of my attached spreadsheet. But it does not seems to work. My input values are obtain using pivot tables. Basically I am trying to read values in colu...
Riny_van_Eekelen
Mar 04, 2021Platinum Contributor
Liphor See attached. When you select a cell in a pivot table the link is not dynamic. You need to go in and exchange the hard-code years to cell references.
Liphor
Mar 04, 2021Brass Contributor
Noted.Thank you