The cubecell formula in 2007 should return a 0 rather than a blank string or
at least give you the option of what to return like the old Excel Add-in for
Analysis Services did.

Having to check for text everywhere is really a hassle and greatly increases
the time and complexity to build everything.

This is a major issue whe
-You want to build something that will populate over time like sales by
month and you want to set up the future months to populate as they happen
even though there is no data yet. The formulas needed greatly increase the
amount of work required compared to Excel 2003.
-You are using slicers and by changing the restrictions you restrict certain
cells to no values (for example if it is sales by salesperson and you select
a period in a slicer where they have no sales)

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions