Worksheet Functions
 

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

Worksheet Functions
 

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.

Worksheet Functions
 

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.

Worksheet Functions
 

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?

Worksheet Functions
 

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.

Worksheet Functions
 

Can you post your formula that's misbehaving?

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

Worksheet Functions
 

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.

Worksheet Functions
 

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?

Worksheet Functions
 

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

Worksheet Functions
 

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.

Worksheet Functions
 

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

Worksheet Functions
 

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

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

Worksheet Functions
 

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
---
"Steve Peel" wrote in message
...
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 happening during
recalculation.