Category Archives: Excel
When trying to install Xcelsius with pre-installed Excel 2010 you will get an error message as Office 2010 is not supported yet by SAP BusinessObjects. One solution is: 1. uninstall Office 2010 (do not forget to backup settings) 2. install … Continue reading
Use the custom format option in Excel if you want to dynamically change the vertical axes labels to a alert color. Eg. [Blue][>0]#,##0;-[Red]#,##0 will show positive numbers in blue and negative numbers in red.
If you work with the Live Office Comptaibility enabled in Xcelsius, changes are that you cannot open an Excel file from the network anymore. However when strating Excel and then navigating to the file on the network in Excel itself, … Continue reading
In Excel 2003 the Weeknum() formula will only be activated when the Analysis toolpack is installed. Go to Options -> Addin -> select Analysis Toolpack -> OK. The formula should work now. Furthermore if you use the Dutch version of … Continue reading
Excel sheet formula translation English to Dutch and vice versa. Functies_Excel_NL-Eng-VBA.xls
2Excel on Apache Tomcat Server «·····» 2CSV on .NET Server «·····» Other formats Export to Excel on Apache Tomcat Server Luca Spinelli and Ivan Aguilar from ClearPeaks (www.clearpeaks.com) introduce users to the new export to Excel solution for Xcelsius using … Continue reading