Does my computer need to be on so the queries are refreshed properly?

No, the refreshes run on our servers so you don’t need to have your computer on in order for them to work.