Formula

[Pamela]

I have received an old spreadsheet built awhile ago. There is a hidden
formula and I can't figure out how it gets there.

Example. if I punch a number in F8 the H8 appears with =D8-F8. it is not
protected or hidden and no conditional formatting that I can see.

its driving me crazy!

 

[Eduardo]

Hi,
check if there is not a formula in the tab, right click on the mouse in the
tab name, view code

hope this helps

 

[Pamela]

Hi, thanks for quick reply.

I am viewing the code but not familiar with this. what am I looking for to
see if there is a formula?

 

[Eduardo]

Hi,
when you click on View code, something show up if yes post what is in there

 

[Pamela]

there is nothing in the main screen but on the left there is one True, enable
calculation

 

[Eduardo]

Ok,
so let's start over, to understand before you punch a number in F8, there is
no formula in H8, but when you punch a number the formula shows up, ??

 

[Pamela]

Thats right. But when I delete the number in F8, the formula stays there.

I could email you the spreadsheet.

 

[Eduardo]

yes please,
(e-mail address removed)

Thats right. But when I delete the number in F8, the formula stays there.

I could email you the spreadsheet.

 

[Pamela]

yes please,
(e-mail address removed)

 

[Eduardo]

Hi Pamela,
Sorry but you are right, there is nothing that I can find, I will take a
look later when at home

 

[Pamela]

ok, thanks.

I think it has to be some imbedded if or formatting.

let me know if you have any luck.