New answers tagged google-apps-script
I came here to look for an answer too for the same situation (calling data from external resource), but have since worked out an alternate method that works so I thought I'd share. This is by no means the technically savvy way to do it, but if you delete the cell, then undo, it will reload. Works a treat.
Is there a way to make this function also run in published document mode? The short answer is, unfortunately, no. The published version of a spreadsheet has many functional limitations, and this is one of them.
Top 50 recent answers are included