FAQ
What version of Excel does this support?
This addon will only work with the Windows Desktop version of Excel 2013/2016/365.
Does this work on Mac?
Excel Online and Excel for Mac are not supported.
I found a bug, what do I do?
Send an email to support@flexfinancialreporting.com. You must include the following...
- A description of the error
- Steps to reproduce the error (simply bullet point what you did)
- Ideally a one or more screenshots (make sure to redact any private information)
I want suggest a new feature, what do I do?
Send an email to support@flexfinancialreporting.com. You must include the following...
- A description of the feature
- Describe a typical use case or how you intend to use it
Technical Issues:
Installation Errors
Installation errors are always one of the following:
- Permissions
- Prerequisites
- Virus scanner/firewalls
So try the following:
- Make sure Windows and Office are fully up to date
- Install the addon as Administrator first, then install again under your profile
- Install VSTO 2010
- Install Office PIA
- Make sure you have .NET 4.7.2 runtime installed
- Make sure you have you virus scanner/firewall disabled during the install
- Install it on a different machine (like a personal laptop or some other machine that is not configured like your work PC)
Forbidden Error
You'll get a Forbidden or Unathorized error when a connection expires. This can happen if you disconnect, haven't accessed the organisation in a long time or if you link the organisation using the same Xero credentials to a different Flex account. To Fix this, simply Reconnect
Addon Disappeared
If the addon crashes or you shut down Excel whilst it’s busy, then Excel will disable the addon as a safety measure. To re-enable the addon, follow the steps here: https://msdn.microsoft.com/en-us/library/ms268871.aspx
The value of property ‘type’ cannot be parsed
Run the installer as Admin first, then install as the user. Alternatively, try these steps:
- In Windows Explorer, navigate to the VSTO 10.0 folder
- The path indicated in the error message which should be something similar to C:\Program Files (x86)\Common Files\Microsoft shared\VSTO\10.0 or C:\Program Files\Common Files\Microsoft shared\VSTO\10.0.
- In that folder, you should find a file named VSTOInstaller.exe.config. Rename it to VSTOInstaller.exe.config.old. (Ignore the warning from Windows about the file becoming unusable)
- Run the install again.
Data Source Reference is not valid
Try the steps here: https://support.microsoft.com/en-au/help/2862807/excel-pivottable-error-data-source-reference-is-not-valid. For Excel 2019 users, this seems to be a bug in Excel. As a workaround, in the Excel Ribbon bar, use INSERT > Recommended PivotTables, then click Blank Pivot Table (bottom left of the form).
Keyset does not exist
When you create a table using the Flex addon, the filter parameters are stored in the workbook so that when you refresh, those same parameters are reused. If you get this error, it means it cannot find a parameter that it need to refresh the table – this is usually caused by updating the addon to a newer version and we've added a new filter option. To fix it, select each table in turn, then click Refresh > Refresh Selected and rerun the table. After you have done this for all tables in the workbook, the Refresh All command should work again.