Question Re: Problem Refreshing Excel Data Source in Technology Q&A

Problem Refreshing Excel Data Source

Former Member — Wed, 20 Aug 2008 16:42:16 GMT

I have created a report that uses an Excel spreadsheet as a data source. The data that resides in the Excel spreadsheet is actually linked from a backend SQL database. When I attempt to refresh the data from within Crystal Reports, it will not pull in new data unless I first open the Excel spreadsheet from within Excel. I have configured Excel to automatically refresh the data when the spreadsheet file is opened. However, that seems to have no effect when the Excel file is accessed from Crystal Reports.

The data that I need from the SQL database resides in multiple tables that need to be consolidated. And there is no way with Crystal Reports to consolidate data from multiple tables into one table, otherwise I would just use the SQL database as my data source instead of Excel.

Re: Problem Refreshing Excel Data Source

Former Member — Wed, 20 Aug 2008 16:44:38 GMT

Hi Rob,

Why not just create a view and link the 2 tables of similar data together.

Then connect your report on the view?

Re: Problem Refreshing Excel Data Source

former_member260594 — Wed, 20 Aug 2008 21:25:25 GMT

Rob,

Crystal is reporting off of the xls file, therefore until the new data is saved Crystal will continue to see the data from the last save. Perhaps you can set up a macro in Excel to save as well as refresh.