Hi,
I need to drag the formula across that includes the links to another spreadsheet (from one month to another, includes multiple cells), but it seems like it asks me to update the values/ link for each cell! I tried to go through data-edit links and update links first before dragging across, but still when I drag the formula for next month it asks me many times to update the values which drives me crazy. Any idea what is the issue? Thanks a lot!
I need to drag the formula across that includes the links to another spreadsheet (from one month to another, includes multiple cells), but it seems like it asks me to update the values/ link for each cell! I tried to go through data-edit links and update links first before dragging across, but still when I drag the formula for next month it asks me many times to update the values which drives me crazy. Any idea what is the issue? Thanks a lot!