If you were asking about my excel process, yes. Once you create the workbook you can set it to refresh upon opening. So, whenever the user opens the file it...

That was an interesting article but there is another way to go I use - which doesn't involve SSIS (which I don't have).

Basically, you can make a refreshable query table...