Forum Discussion
Some formulas in excel copy but don't compute.
I am having a situation in editing in Excel, Office 365. I can copy and paste a formula =SUM for a column or row. The formula shows but the column or row doesn't compute. This doesn't happen for every row or column. Some do and a few don't. I have tried deleting the formulas and retyping them. Is there something else I can try?
9 Replies
Hi Sandra,
could you please double check if the cells with non-computing formulas are text formatted (right click->format cells? This would cause formulas showing and not calculating. Another possiblilty is if you have circular references in the workbook. You can double check it in Formulas->Formula Auditing->Error Checking->Circular References. Please let me know if any of these is present in your workbook
Thanks
Yury
Yuri
They are currency formulated. Where do I access a tab for Formulas and Formula auditing? I have not found any circular references. I appreaciate your assistance in this problem of mine. I have been using the spreadsheet for my cash flow for going on three years and use the total amounts to do my taxes and those of my daughter. The system has been almost flawless until now. I have had some circular references and been able to correct them. Nothing like the present situation have I any experience with.
Thank you!
Sandy
Hi Sandra,
would you mind sharing the part of the file, where the formulas do not work?
In relation to circular references, if you select the 'Formulas' tab on the ribbon, then in the 'Formula Auditing' area there is an 'Error Checking' button with a small arrow on the right side pointing down. If you click the arrow, it will expand to 3 options, including 'Circular References'.
Thanks
Yury
