It's been suggested I start a new thread on this issue:
In the workbook I'm using, I am linking a row of numeric data from one worksheet (the "original worksheet") to another worksheet (the "second worksheet") within the same workbook. However, when I copy the link to the second worksheet, some of the numbers change such that my row totals are different. See snippet below.
Note the range of numbers changes beginning in April (orange highlight). Also note the totals are now different ($7,993,233 vs. $7,998,898). The numbers in the top row of the snippet below are correct --- they are from the original worksheet. However, after the link is copied down the row in the second worksheet, I end up with different numbers on two different sheets that should be the same. I inherited this workbook from a predecessor and I tried to clean out all the old named ranges with errors in them (used the shift key for power deletion of old named ranges) thinking that might help. I have cleared everything out of the rows involved in the linking. I don't remember ever seeing anything like this in all the years I've been working in Excel. I'm stuck and unable to progress any farther in this workbook at the moment. Any help would be greatly appreciated. Thank you.
In the workbook I'm using, I am linking a row of numeric data from one worksheet (the "original worksheet") to another worksheet (the "second worksheet") within the same workbook. However, when I copy the link to the second worksheet, some of the numbers change such that my row totals are different. See snippet below.
Note the range of numbers changes beginning in April (orange highlight). Also note the totals are now different ($7,993,233 vs. $7,998,898). The numbers in the top row of the snippet below are correct --- they are from the original worksheet. However, after the link is copied down the row in the second worksheet, I end up with different numbers on two different sheets that should be the same. I inherited this workbook from a predecessor and I tried to clean out all the old named ranges with errors in them (used the shift key for power deletion of old named ranges) thinking that might help. I have cleared everything out of the rows involved in the linking. I don't remember ever seeing anything like this in all the years I've been working in Excel. I'm stuck and unable to progress any farther in this workbook at the moment. Any help would be greatly appreciated. Thank you.