I had created an Excel report that connects to an ODBC to pull data from SQL. When I refresh, I would like to remove items from the Excel spreadsheet and re-populate with all new data. Is this even possible?
The issue, I'm currently running into is that the ODBC would pull new data, and old data that should not be on the report any more are still there. Not sure if this is a setting thing in Microsoft Excel 2010 or what. I can't quite recalled, but didn't seem to be doing this when it was originally setup in Excel 2003.