I have a workbook with 12 worksheets, one for each month, all identical except for a column that adds the cumulative of the previous months. So in Jan, the cumulative is Jan. In Feb, its Jan + Feb. In Mar, it's Feb(cumulative) + Mar. And so on.
If I need to edit the sheets, I do all of them at once. But I have noticed a problem. If I need a new line, I copy one row and insert it where I want the new line. This ends up shifting the formulas. So now for the cumulative, instead of Mar!K22 = Feb!K22 + Mar!S22, I have Mar!K22 = Feb!K23 + Mar!S22. This happens only on the page I do the insertion. The other pages seem to be fine.
I don't have this problem if I do a cut and insert. I can't figure out why this happens. The current workaround that I use is to insert a blank row, and then copy and paste. But I want to know what I am doing wrong.
Help, my PC with Windows 10 won't shut down properly
Since upgrading to Windows 10 my computer won't shut down properly. I use the menu button shutdown and the screen goes blank, but the system does not fully shut down. The only way to get it to shut down is to hold the physical power button down till it shuts down. Any suggestions?