Forum Discussion
Some formulas in excel copy but don't compute.
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
Here is the file, I think. My sharing abilities are not practiced. I hope this helps.
Sandra
Hi Sandra,
as Sergey mentioned, there are multiple circular references in the file. You need to resolve them all for the formulas in the worksheet to work correctly
Yury