The only thing that comes to mind is Section Access security limitations. When you reload the document manually, you see ALL the data. When you close and re-open the document, you see the data that your User ID has access to.
Other than that, your Gauges should be updated with fresh information when you reload.
Another thing to check out is any macros or actions that might be triggered on the "On Open" event.
