Worksheet Functions

  • Thread starter Thread starter Steve Peel
  • Start date Start date
S

Steve Peel

My simple formula referencing the value of another cell is written over by
that value when the value of the referenced cell is changed? This is a
strange question for me to ask because I have been working with excel for
over a decade and have never come across this before
 
smartin said:
Is the referenced cell in another workbook? That is the only way I know
for a formula to be overwritten by a value -- and then only when the
link to the external workbook is broken.
Click to expand...

No, in fact it is only 2 colums to the right???
 
Do you have an event macro that may be changing the cell?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
There are references to other workbooks within this workbook, but not on this
sheet, and the links are not broken....
 
The formula in N2 is being overwritten by the date in P2 when ever it is
changed. I fixed the problem by protecting the sheet, but it forced me to
add many unprotect lines in my VBA code - very time consuming.
M N O
P
1
2 Week Ending Date =P2 Week Ending Dates 39690
3 Monday =N2-5
4 Tuesday =N2-4
5 Wednesday =N2-3 LastWeeksTracker =P2-7
6 Thursday =N2-2 ThisWeeksTracker =P2
7 Friday =N2-1 NextWeeksTracker =P2+7
8 Monday =N2+2 SaveBookBoolean Yes
 
This is a large workbook with many pages of VBA code. However, on this
particular sheet there are no procedures at all - no "SelectionChage" or
"Activate" or "Deactivate" procedures, none at all. This is happening during
recalculation.
 
Sorry about the misaligned worksheet I tried to copy in. That would be the
first place I look, but this is happening when I maunally change the date in
cell P2 directly on the sheet. So it is definitely happending during
recalculation.
 
Don't have any further clues. Still believe the phenomena you describe has
to do with some code (Worksheet_Calculate?). Why not take it up further in
..programming?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400, Files:358, Subscribers:55
xdemechanik
 
Back
Top