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
Sergei - thanks for the reply - nope, its relative references and the auto recalculation is turned on, and its only certain columns that have this issue
All columns are formatted identically, no text formats in the middle?
Yes- just rechecked - all $ format - it only seems to be columns U - V - W - X - Y - all other columns work - and only on certian rows when I copy/past - its shown up on other sheets of the same workbook
It looks like you copied the sheet into another and some formulas keep references on initial sheet - something like this?
Could you show how the formula looks like for one of yellow cells and for another one with correct result (what do you see in formula bar)?