Verify the configuration files.
When you open Anaplan XL, you get the message:
There was an error during processing of C:\Program Files (x86)\Anaplan\Anaplan XL Reporting\XLCubed.dna: There is an error in XML document (0, 0). The type initializer for 'System.Xml.Serialization.XmlSerializationReader' threw an exception.
This error can be caused by problems with one of several configuration files:
- XLCubed.dna, XLCubed64.dna, XLCubed.xll.config or AnaplanXL64.xll.config, all found in the Anaplan XL Reporting installation folder (usually C:\Program Files (x86)\Anaplan\Anaplan XL Reporting)
- Excel.exe.config, found in the Excel installation folder (usually C:\Program Files (x86)\Microsoft Office\Office15 or similar)
- machine.config, found in the Microsoft.NET configuration folder (usually C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config and C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config)
The problems can be caused by several underlying issues:
- The files don't exist (except for XLCubed.xll.config and Excel.exe.config, which aren't necessary)
- The files exist, but are protected and not accessible by Excel while it's loading
- The files exist, but are corrupted
In particular, the installation of some IBM Client Access providers can cause problems with the machine.config file.
