XL Connect - formula dragging

littlesistersba · July 30, 2020, 7:59pm

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?

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

Thanks
Pete

littlesistersba · August 27, 2020, 5:39pm

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

Thanks
Pete

Mike · August 28, 2020, 9:42pm

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

littlesistersba · September 2, 2020, 2:35pm

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