Issue

Trying to run an Excel Jet Report and getting message with Excel naming a different spreadsheet then the one currently open. Steps:  Open Excel Report 'Report A.xls' > Tools > Report Message: 'Report B.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved or deleted. Additional Data: The user has not renamed report, updated MBS Office (AKA Excel), installed new Jet Report version and was able to successfully run report last week. They emailed the report to another user and it opened & ran successfully.  User is a designer and says the spreadsheet does not have any links to 'Report B' or any other spreadsheets.

Solution

#1: Check for any formulas in the report referring to another spreadsheet Open workbook > Tools > Options > View > check Formulas (repeat for each worksheet) Look for any formula reference to another spreadsheet or workbook #2: Reset the Jet Report Add-In in Excel The problem is that Excel has somehow lost the location of the JetReports Add-in. To fix this, go into Excel/Tools/Add-ins. Click on Browse and navigate to the c:\Program Files\JetReports\ folder and open the JetReports.xla file. Excel will ask to replace the current JetReports add-in. Choose yes and then click OK to get back into Excel. Close Excel and re-open to save the settings.