Does anyone know how to refresh pivot tables in Sharepoint?

I have no problem with pivot tables on the desktop, but I can't get them to
work in Sharepoint. The source is in Sharepoint. I have no problem building
the report (probably because the source is open), but when I close the source
and try to refresh the report, I get errors because the connection is lost.

Help!