Worksheet Functions

[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]

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

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.

 

[Steve Peel]

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.

No, in fact it is only 2 colums to the right???

 

[smartin]

No, in fact it is only 2 colums to the right???

Hi Steve,

And 2 columns to the right, as you say, you have no external references
there either (or dependent references to the same)?

IOW, are there references to another workbook anywhere here that might
be breaking?

 

[Steve Peel]

No, the formula is only 2 columns away on the same sheet...

 

[Max]

Can you post your formula that's misbehaving?

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---

 

[Sandy Mann]

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

 

[Steve Peel]

There are references to other workbooks within this workbook, but not on this
sheet, and the links are not broken....

 

[Steve Peel]

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

 

[Steve Peel]

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.

 

[Max]

I'm not sure that its a worksheet function issue. You might want to try
posting in .programming with the code that's writing stuff into the sheet.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik

 

[Steve Peel]

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.

 

[Max]

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