You can force it to update very frequently, or when you push a button.

You can also use PowerQuery (formerly known as Data Explorer).
http://datapigtechnologies.com/blog/...data-explorer/