Excel column widths changing upon data refresh, DESPITE "adjust column widths" being unchcked

I'm in the latest version of Excel 365, and have a data connection set up to a php page on my website. It works flawlessly, but every refresh makes the columns default back to being just wide enough to fit the source data.

BELOW the data-connected table, I have other formulas/values. These are longer strings, and as such they end up as "#####" when the column sizes get adjusted to match the incoming data.

What can I do to prevent this? With that checkbox unticked this sounds like it's a bug, would you agree?

Thanks!

Recent Questions...