Unable to lock cell range to autofill formulae

I’ve linked one part of my formula to a cell range in another worksheet within the same workbook, and ensured that the formula locks the cell range. However, when I drag/autofill the formula to other cells, the formula does not respect the locking. I’ve replicated the same setup on Excel, where I did not face this issue. Any help/work-around on this is appreciated!

Hi @Deepak_VS,

Thank you for reporting this issue.

We have identified auto-fill incorrect behavior specific to formula expressions with implicit cross-row cell-ranges of the form $1:$1. Tracking this as #004131.

We will be addressing this issue in one of our forthcoming releases.


Issue #004131 is fixed with the latest upgrade.