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

Steve Peel wrote:
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.

smartin" wrote:
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" wrote:

Steve Peel wrote:
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 wrote:
smartin" wrote:
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???

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?

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

"smartin" wrote:

Steve Peel wrote:
smartin" wrote:
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???

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?

Can you post your formula that's misbehaving?

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

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




"Max" wrote:

Can you post your formula that's misbehaving?

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

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" wrote in message
...
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

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

"smartin" wrote:

Steve Peel wrote:
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.

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


Replace @mailinator.com with @tiscali.co.uk


"Steve Peel" wrote in message
...
No, the formula is only 2 columns away on the same sheet...

"smartin" wrote:

Steve Peel wrote:
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.

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.

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Steve Peel" wrote in message
...
No, the formula is only 2 columns away on the same sheet...

"smartin" wrote:

Steve Peel wrote:
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.