Help center

View helpful articles, tutorials and FAQs on the set-up and configuration

of the FocalScope omnichannel suite, according to best practice.

I get an ‘Access denied’ error with an Excel live report


For Excel live reports, Excel retrieves the data to populate the report directly from FocalScope's database. It is therefore necessary to allow Excel to access this information by enabling live Excel reports in FocalScope.

Symptoms

An access denied error is show in Excel when a FocalScope live report file is opened.

Cause

Live Excel reports have not been enabled in FocalScope. This causes FocalScope to deny the request for data from Excel when it tries to retrieve the report data from FocalScope's database.

Troubleshooting & Solution

To verify if you have live Excel reports enabled, follow these steps:

  • In the [Main menu], select [Screen > Administration]
  • Click the [Advanced properties] tab
  • Select the [Fine tuning > Reporting] folder
  • In the right-hand pane, tick the [Enable "live" Excel reports] flag
  • Click [Save] to commit the changes

Excel should now be able to access the FocalScope data and populate the report(s).



Figure 1 - Enabling live Excel reports





Let us help

If you have any questions, or need further support, please don’t hesitate to reach out.