Excel prompt Office File Validation error message "Office has detected a problem with this file"
Symptoms
You receive the following error message on Excel when trying to use the Infront Excel add-in: Office has detected a problem with this file (...):
Solution
To set up a trusted location, follow these steps:
- On the File option, click on Options and select the Trust Center option. Click on Trust Center Settings button
This activates the Trust Center dialog box. - On the left, click Trusted Locations.
The Trusted Locations menu appears, displaying all the directories that are considered trusted.
- Click the Add New Location button.
- Click Browse, enter “%LOCALAPPDATA%\Infront Analytics” and click Ok.
- Check “Subfolders of this location are also trusted”
Once you specify a trusted location, any Excel file that is opened from this location will have macros automatically enabled.
Navigation menu
- Excel Add-in Help Center
- Infront tab and ribbon missing when I open Excel
- Unable to connect to Infront Analytics server
- Error when opening a workbook: “Security warning…”
- Error when opening a workbook: “This workbook contains links…”
- Error when opening a workbook: “We can't update some of the links…”
- Error when refreshing a workbook: “The file could not be accessed…”
- Error when refreshing a workbook: “Cannot run the macro…”
- #Err Rate message displayed in cell
- #NA Period NoPerm message displayed in cell
- Infront new customer installing the add-in: login box keeps on appearing
- Error when trying to use the add-in: "The program can't start because api-ms-win-crt-runtime-I1-1-0.dll is missing..."
- Error when trying to refresh an Excel model or connect to the Infront Analytics Engine
- Cyber security solutions prevent the add-in from working properly
- Error when refreshing a model: "Sorry, Excel can't open two workbooks with the same name at the same time"
- Function module Excel add-in disabled
