Forum Discussion
Several Problems with latest spreadsheet
I have been using Excel for a while. My latest spread sheet is having several problems, probably related.
- Numbers in the sheet do not appear in the formula bar
- Going along with this, the autosum does not add up a column and the formula also does not appear up top
Thank you for any help. Probably something simple I did on the sheet.
Fred
7 Replies
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
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.
