Most macro functions do not work when called on an OnOpen event on the server. Your best bet is to schedule the reload to happen reasonably frequently on the server. This way fresh data is waiting for the user when they open the document.
How frequently you reload should depend on how long the reload takes and how fluid the data is behind the document.
The reload trigger and partial reload trigger do not work in AccessPoint, only in Desktop. If I am wrong and it can be performed please correct me, but I speak from my experience, I've tried several times with different changes and even consulted here in the community but unanswered.
You should try with an alternative, performing reloads at the QMC, or change the logic that you are thinking to solve the business requirements.
You can do a reload from Access Point by triggering an EDX call on the load. If you only have Server you can only have one reload task - so you couldn't have a scheduled one and an EDX one - with Publisher you don't have that limitation.
The EDX task could be started by writing a bit of ASP code on the web server and linking to that URL from inside QlikView. Alternatively an extension could be used to call the URL - there is a very neat one by Stefan Walther which I have not had the chance to use myself yet, but looks like a very good solution:
