XL Connect - formula dragging

[littlesistersba (Kristen Smith)]

Anyone have any thoughts? Sometimes this works and sometimes it doesn’t. “Automatic” is selected as my calc option in excel.

Thanks
Pete