teachamantofish
New member
Hi,
I recently discovered quite by accident that exporting to Excel and pasting into the .xls creates a spreadsheet with live data via Excel's RTD formula. My google searches and TOS support request have confirmed it's not possible to do the same for Google Sheets directly. However, I'm sure there are workflows that can be created for this. So my question is rather general: What workflow do you suggest that's relatively simple and scalable? Hopefully free.
So far I'm favoring a GS add on called Coefficient, but perhaps there are better ways.
TIA.
I recently discovered quite by accident that exporting to Excel and pasting into the .xls creates a spreadsheet with live data via Excel's RTD formula. My google searches and TOS support request have confirmed it's not possible to do the same for Google Sheets directly. However, I'm sure there are workflows that can be created for this. So my question is rather general: What workflow do you suggest that's relatively simple and scalable? Hopefully free.
So far I'm favoring a GS add on called Coefficient, but perhaps there are better ways.
TIA.