Tag Archives: Excel
If eg. Treasury is maintaining a Tax Rate by country list in the Corporate Sharepoint directory, you can import that list into Xcelsius for use in your dashboard without setting up a portal provider as you do not want to … Continue reading
Now I always hate it when someone comes with an Excel chart that I have to duplicate. Excel is THE manupulation tool a user can have, thus ofcourse the chart capabilities are endless. And as Xcelsius is based on Excel, … Continue reading
I tried to install fixpack 3.5 and got the error message that I need Office XP or a newer version. However I do have Office2010 installed. So I thought to do the same as in my previous post, I hacked … 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