XL Docs breaking all references
We are just beginning to play with the XL Docs extension. I've got a subtable that is populating data on sheet 2. When I generate the doc the data appears there as desired, but on sheet 1 we have a c...
Forum Discussion
I have found a workaround. Turns out Excel doesn't like that rows are being added by XL Docs when he sheet is generated. For whatever reason, even though the formula was set to count the entire column anyway, adding rows only works if you make the starting of the column reference static. So =COUNTIF('MASTER LIST'!$F:F,C2) Only sticks around with the $ on the first F. Any formula on Sheet 1 that does not reference sheet 2 still works.