Problem Refreshing Excel Data Source

[Former Member]

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.

[former_member260594 · Accepted solution]

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.

[Former Member]

Hi Rob,

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

Then connect your report on the view?