V
velcero
I've recently mapped a row containing formulas to an XML schema. The
forumulas work with data in other worksheets within the same workbook. If I
try to edit the formulas within the map, the cell is filled with "######" and
the formula is converted to a constant. If I audit the formula, the correct
result is displayed in the dialog box. However, I can not get the forumula
to function in the worksheet. I've tried copying the row to a new worksheet
to edit, however this same problem is copied with the cells. Any suggestions?
forumulas work with data in other worksheets within the same workbook. If I
try to edit the formulas within the map, the cell is filled with "######" and
the formula is converted to a constant. If I audit the formula, the correct
result is displayed in the dialog box. However, I can not get the forumula
to function in the worksheet. I've tried copying the row to a new worksheet
to edit, however this same problem is copied with the cells. Any suggestions?