If your dataset contains formulas that reference other columns within the range, you'll need to recreate these using structured references once you've formatted the data as an Excel table.

Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a spill range so you can use the hashtag shortcut.