I wrote a function to pull data from an external table. I am running into
the following issue - when the data in the table updates, my spreadsheet does
not. While I do not want my spreadsheet to update automatically, I would
like to update it on a demand basis. I have tried the refresh data option
under the Data menu, but it is "grayed" out and not available. I have
likewise tried the Refresh All button under the External Data menu. While
this button "clicks", my information does not updage.

Any help would be greatly appreciated!