Forum Discussion
Several Problems with latest spreadsheet
This a money program that I made up and have used for 25 years originally with quattro. I decided to switch it to Excel since all my other spreadsheets have been switched to Excel. The way it works is I put down the number of hours and the week number and this is transferred to the approriate line for the employee.
The problem is the same for all of the employees. Start at AT25 and go across, the sum function is not working.
Thanks,
Fred
The attach icon below is not working for some reason. I am not a computer person. Is it possible for me to send it to your email?
Thanks for sending the workbook.
If you look at the status bar, you should see 'Circular References'. There is a whole series of cells whose formulas refer to the cell itself. For example, AT11 contains the formula
=IF($H$16=$AS11,F$50,AT11*1)
You can get around this as follows:
Select File > Options > Formulas.
Tick the check box 'Enable iterative calculation'.
The SUM formulas should then work.
But I don't know whether this is what you intended.
- drferdbJan 16, 2025Copper Contributor
+Good morning Hans-I must have a different version of Excel. By hitting the Formula Bar, at the end of it shows Watch Window and the next block over has a square saying Calculation Options with a small down pointing arrow to open. It gives me 3 choices: Automatic which is checked, Automatic except for Data Tables, and Manual. The bar ends with 2 small buttons, Calculate now and under that Calculate sheet.
Thanks,
Fred
- HansVogelaarJan 16, 2025MVP
As mentioned in my email message:
You should activate the File tab of the ribbon (the left-most tab), then select Options.
In the Excel Options dialog box, select Formulas in the navigation pane on the left hand side.
You should see the 'Enable iterative calculation' check box under Calculation options.
- drferdbJan 15, 2025Copper Contributor
Thanks Hans, appreciate it. When I get back to the office I will give it a try.
Once again, Appreciate it
Fred