Skip to Content
0
Nov 16, 2012 at 03:53 PM

BO Analysis for Excel ODBC connection

122 Views

Hi folks,

I have created a bunch of reports in Excel using Business Objects Analysis connecting to HANA via ODBC. Since then we have upgraded our hana db and our ODBC connection info has changed. So I updated my ODBC connection to point to the new db name. Now when I refresh any of my old reports in Excel it attempts to connect to the original ODBC connection. This makes sense and I expected that to happen however I can't seem to find where this setting is saved. Does anybody know how I can change this in the workbook without having to recreate from scratch? The odbc connection seems to be somehow embedded in the workbook but I can't find how to change it.

Thanks!