<div>
<div class="content wysiwyg-content">
I have a CR based on an Excel table. &nbsp;When I go back to the table in Excel and add a column, I cannot figure out how to refresh that in CR so that I can add that field to my report. &nbsp;(I also have the same problem when I just change a column name in the Excel table) &nbsp;I saved both and exited and re-entered and they didn't refresh. &nbsp;I also tried going to the field explorer and right clicking on 'Database Fields' and choosing refresh, and that didn't work. &nbsp;I also did the same thing to the icon below it - the icon that shows the sheet from the Excel workbook.<br />
<br />
What am I missing here? &nbsp;Thanks
</div>
</div>


I have a CR based on an Excel table.  When I go back to the table in Excel and add a column, I cannot figure out how to refresh that in CR so that I can add that field to my report.  (I also have the same problem when I just change a column name in the Excel table)  I saved both and exited and re-entered and they didn't refresh.  I also tried going to the field explorer and right clicking on 'Database Fields' and choosing refresh, and that didn't work.  I also did the same thing to the icon below it - the icon that shows the sheet from the Excel workbook.

What am I missing here?  Thanks

Refresh Database Fields in report connected to Excel table

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.