Forum Discussion
Some formulas in excel copy but don't compute.
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
Because of your help I am searching through the file and correcting my formulas. I know my sheet is sophomoric and would gladly accept any instruction on improving it. Thanks again!
Sandy
Circular references is in row 251 (at least). See AC251, etc.
In general, here is much better to use SUBTOTAL instead of SUM
Thank you so much for the imput. I will look into SUBTOTAL.
