Forum Discussion
copying the @sum formula gives values in certain columns
Sergei - thanks - I will check for circular references and if that doesn't work, attach the files
John, my last guess that's if you have circular references somewhere in calculations, not necessary in rows 10-19. It looks like numbers in row 12 are taken from row 7. If calculation for row 7 has circular reference, not necessary in the same sheet, sum for 10-19 won't be updated.
If that's not the case perhaps you may attach the file to check removing all sensitive information and sheets/numbers are not used.
Sergei - thanks - I will check for circular references and if that doesn't work, attach the files
yes - thanks again - I was not optimistic that this random error could be fixed
Glad to know, one more issue less in this life
Wow - that worked - a circular reference on another sheet that fed into the sheet that was giving me the problem - thanks so much
