why do cell values change with changes in unrelated cells

H

hung up

I am developing a work book. I find that when I insert a value in a cells,
nearby cellsm, with no direct or indirect connection, change. What do I need
to do to stop this happening?

Product - exel 2008
 
B

Bernie Deitrick

hung up,

Making a change may force a recalc, in which case any volatile function may change - say, if they
are date or time related. Beyond that, you would need to post what your nearby cells contain.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Turning off automatic calculation 0
Drop down list control value in vba 2
External cell reference between two excel worksheets both in One Drive 0
How to synchronize all cell values? 1
VBA word change keys 0
Find text in cell and copy from 4 characters in front of the found text. 2
Add value of (1) to a selected cell or cells 2

Top