Category Archives: Excel
Do you know these tricks?
During the last couple of months I have discovered some usefull tricks, which in turn are too small for a post on its own, so I have combined them into this one. Formula for calculating the maximum scale for chart … Continue reading
“Empty” value in optional prompt in Bex query
I finally found the solution for the issue with the optional prompts and the empty value string when connecting through BICS to a Bex query. Unfortunately BW does not view the Excel formula =”” as an empty string as thus … Continue reading
Values send as text by BIWS connection
I have spend some frustating hours trying to figure out, why my number format did not work properly in my preview mode. Data was brought in the dashboard by BIWS connection. I thought it had to do with the locale, … Continue reading
Ranking without repetitive values
Here’s a question I get asked a lot: “I’m trying to use the RANK function to sort the values in Column A, but, the problem arises when I have two or more cells with the same value. Then, the RANK … Continue reading
Xcelsius chart versus Excel chart
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
Installation Fixpack 3.5 and Office2010
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
