a few ideas
you can create a 'live' connection in an excel file and just let them right click and refresh the data on demand but this requires imbedding a open password.
You can set up an SSIS package or its equivalent to export the data on a schedule, not using crystal at all
You can get a crystal add on (I use VisualCut) to set scheduled reports to burst files or emails.