Dynamic print range using Offset works on one sheet but not another Office 365

I'm using a Dynamic print range in Excel to contain the print region to print only lines that don't start with "N/A". I've been using this exact formula for years. Today, for some reason, it works in one workbook but not another! I'm running out of hair to pull.

We switched to Office 365 this year and I'm wondering if there's some setting or option I'm not aware of that's not letting this run. The workbooks that it works on were created before we moved to 365 and I no longer have 2010 to test this theory on.

Here's the formula - but as I said it works in other workbooks:

=OFFSET('LC5001 Script'!$A$5,0,0,COUNTIF('LC5001 Script'!$A$5:$A$153,"<>"&"#N/A"),8)

I split out the COUNTIF function and it still works perfectly.

To make this more annoying, when I unprotect the sheet so I can select the print range formula to copy it for pasting here, a green dashed outline appears and circles around the desired print area! It really seems like it should work, but something is blocking it. Unprotecting the sheet doesn't help.