Im using Delphi 10 and TAdvGridWorkbook.
TAdvGridWorkbook is built-up from TAdvStringGrid instances and to work with formulas, it is required this would be TAdvSpreadGrid instances. As such, TAdvGridWorkbook can 't be used for such formula references. You would need to use a TPageControl with different TAdvSpreadGrid instances and TGridBinder component as demonstrated in the TAdvSpreadGrid demo.
Your advice was very helpful. Thank you very much.