Dynamic offset printing not working as expected in Excel

I've got a worksheet that's a template containing 10,000 lines of formulas which simply pull available data from another sheet. I'm trying to make it only print the displayed data, but by default it pulls all 10,000 lines. So I created an entry in the Name Manager called DynPrint with the following formula: =OFFSET('Template Log'!$A$1,0,0,COUNT(IF('Template Log'!$B$9:$B$10000 0,'Template Log'!$B$9:$B$10000)),22) Then on the Print_Area entry I set it to =DynPrint . Initially it works just like I expect it to and only displays the appropriate data to print. But when I open the file and update th

Question by Mark Traylor on Super User, licensed CC BY-SA. We show a short excerpt and link to the original thread as credit.