I am using Microsoft Office Professional 2016 installed locally and have this same problem. I have need for the OFFSET function a lot. Has anyone found a workaround? Is the problem still present on later versions of Office? If "No" and "Yes", does MS have any plan to fix it?