Serious typo !

You could also use either of those methods to create a worksheet level
name (aka local) simply by prefixing the name with the sheet-tab name and
an apostrophe.

that apostrophe should have been an exclamation mark !

'sheet-name'!defined_name

Regards,
Peter T