Skip to Content
0
Former Member
Aug 12, 2011 at 06:22 AM

Xcelsius and relative cell in Excel with empty cells get zero value

32 Views

Hi, gurus.

I have problem with view relative cells, which get data from empty cells. I use live Office and sometimes In data I get empty cell, becouse I have no data. But in my document I use formula like "=D27" where D27 is empty and in cell with formula get zero value. I wanna get same empty cells with formulas, if I have no data. Can I change settings of Xcelsius for that ?

I use Microsft Office 2007 and Xcelsius 2008. I found necessary settings only in Excel, that I can't change in Xcelsius.

Thanks in advance, Ruslan.