XL Connect - formula dragging

Hi,

In XL connect, does anyone know how I can drag a formula down so it picks up the correct column and doesn’t repeat?

image

Probably a simply way to do it, but were new to XL connect.

Thanks
Pete

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

Thanks
Pete

Can you give more info. Show the actual formula in excel in the cell that is working and the cell that didn’t work.

Thanks Mike - I actually figured it out and it was anchoring that was causing the issue. Appreciate you responding though.