Forum Discussion
john g
Aug 25, 2018Copper Contributor
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 ...
- Aug 25, 2018
Sergei - thanks - I will check for circular references and if that doesn't work, attach the files
john g
Copper Contributor
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
SergeiBaklan
Aug 25, 2018MVP
It looks like you copied the sheet into another and some formulas keep references on initial sheet - something like this?