TM1 Forum

Hi,

I have created an active form in Excel 2007. I inserted some more columns and copied the formulas accross which were DBRW formulas. However when I refresh formulae (F9) some of the columns show blanks. When I save the spreadsheet the cells then correctly show the formula result. So there is nothing wrong with the formula per se it just is not displaying the formula result in the cell until I save the worksheet

I suspect it has something to do with inserting columns but I have been careful to only insert columns in the middle not at the ends of the active form. Sometimes the formulas work, sometimes they come up blank. I really cannot understand what is going wrong,

Hopefully there is a simply explanation

cameronfry wrote:Hi,

I have created an active form in Excel 2007. I inserted some more columns and copied the formulas accross which were DBRW formulas. However when I refresh formulae (F9) some of the columns show blanks. When I save the spreadsheet the cells then correctly show the formula result. So there is nothing wrong with the formula per se it just is not displaying the formula result in the cell until I save the worksheet

I suspect it has something to do with inserting columns but I have been careful to only insert columns in the middle not at the ends of the active form. Sometimes the formulas work, sometimes they come up blank. I really cannot understand what is going wrong,

Hopefully there is a simply explanation

Normally this is due to a DBRW that depends on another DBRW (use DBR instead) or you've changed the scope of your columns and your TM1RPTVIEW is excluding the data you're trying to show.

Matt