It looks like ODBC query is not edited (It tries to connect with Excel file in folder of my Excel profile). The Open event must take care of it, but obviously it is disabled currently.

You can open the file anyway when you get ODBC error - simply click Cancel for error messages.

Then you must save the file into folder accessible from your computer (to hard disk, or to network resource - ODBC query reads info from the last save of file, not from instance you are working with). After that close the file and open again - When no error massages anymore, then all is OK.

When you get same error anyway, then check security settings (for macros and external connections).

When you anyway can't get the Open event or query working properly, then the last option is to edit connection manually (from menu: Data>Connections select connection, activate Properties, on tab Definition edit file path in Connection string and Command text.)

As the query reads data from save, when you enter some new transfers and want to see them in report, you have to save the file before refreshing the report.

The report is refreshed, whenever:
1. you open the file;
2. you click on Refresh All in Connections section of data menu;
3. you click on Refresh button in Workbook Connections wizard with connection selected;
4. you right-click on any cell of query's datarange on report sheet, and select Refresh from drop-down menu;
5. You select another company or Finished status on report sheet.