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!
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.