And it’s a funny one. Save all your work, then make up a simple datasource that has a formula in the header:
Now, turn the Macro Recorder on, and while it’s recording, turn that datasource into an Excel Table. (I use the Ctrl T shortcut for that)
Excel will warn you that the formula will be converted to static values. Click No.
Happens for me using Office 365. Pretty obscure, granted.