Dragging cells causes formulas in other cells to not update

nej12

New Member
Joined
Nov 10, 2018
Messages
23
Hi, I'm sure this has been asked a million times, I'm only good at Excel when I really need something to happen, so this means I'm not super good at Excel but I like Excel.

Hoping to get some advice. I use an if, isnumber, search, formula to Simply grab and add up minutes for certain things in a list.

When I drag the cells around to simply swap data from one cell to another (because I just missed typing something else first) the cell with a formula has to be replaced with the same formula in order for it to update the right calculation. The only other work around is to not drag cells and delete and retype.



Any thoughts?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Oh and my formulas are set to calculate. Manual update did not correct plus I don't want to use that.
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,188
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top