Refresh Database Fields in report connected to Excel table
Posted on 2008-06-11
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