How to refresh the data source?

[casper]

Very useful add-in. Thanks for making it public.

One question. What's the best way to get Excel to refetch and refresh the HTTP data?

So far what I came up with is a VB macro like this:

  Application.Run("REQUESTS.FLUSH")

  ActiveSheet.EnableCalculation = False
  ActiveSheet.EnableCalculation = True
  
  ActiveSheet.Calculate

This works but seems very slow. Is there a better way to do this?

[Ethorsen]

I was also wondering the same. Unless I edited the cell, values never seemed to refresh. (even with manual calculation/F9)

Anyway thanks for the workaround casper I implemented it on a button.