MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formulas worked before but do not now


Posted by wdf on February 04, 2002 4:19 AM

I build workbooks for my estimates. each sheet computes cost of material, labor, etc.. The formulas
installed on each sheet have worked consistently for many years. These are simply sum/multiplication and division formulas. I recently downloaded and installed a utility program for excel called asap utilities. After converting the text on some of the sheets to all uppercase it seems that most of the formulas quit working. I can see the formulas in the cells but they do not function. I cannot say that installing the utility caused the problem but it is the only thing I
have done different recently.
Can anyone help????????


Posted by Carl B on February 04, 2002 8:58 AM

Are the formulas looking for certain named cells, or sheet names or text that used to be in lower case and are now in upper case or vise versa?

Posted by John on February 04, 2002 9:11 AM

Your utility may have changed the format of the cells to text. Try reformatting to General.