Forum Discussion
Solved
copying the @sum formula gives values in certain columns
This just started happening a couple of days ago - and only on one workbook - but on multiple sheets. When I copy a simple @sum formula across columns, some of the columns calculate correctly, some of them show the value from the originating cell - any ideas for solutions? Thanks
Sergei - thanks - I will check for circular references and if that doesn't work, attach the files
15 Replies
Hi John,
Do you have absolute or relative references in your formula? And do you see in formula bar what the formula changes for new cell?
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?
