Crystal and Excel Speadsheets

[kutoose]

Is it possible to 'Embed Excel spreadsheet into Crystal Reports as OLE objects' ?

 

[kenhamady]

Try using Insert - OLE Object and you should see Excel as an option - so yes.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[kutoose]

Thanks Ken,

What I am trying to do is this. I have an excel sheet in the server and I can embed it into Crystal Reports.Now the Excel sheets is updated from some other sources. The Excel OLE object in Crystal Reports is not getting updated...

Is there anything I can do so that the Excel Sheets are also updated when I refresh the report ? I am using
Crystal Reports 8.5 and Microsoft Excel 2002.

Wonder how this will behave in Crystal Reports 9

Thanks for your time !

 

[kenhamady]

If you use "Create from File" and check off "Link" you should get an updated spreadsheet each time you open the report.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com