Formula
 

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! :)

Formula
 

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

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! :)

Formula
 

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

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

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! :)

Formula
 

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

"Pamela" wrote:

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

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

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! :)

Formula
 

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

"Eduardo" wrote:

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

"Pamela" wrote:

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

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

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! :)

Formula
 

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

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

"Eduardo" wrote:

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

"Pamela" wrote:

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

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

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! :)

Formula
 

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

I could email you the spreadsheet.

"Eduardo" wrote:

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

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

"Eduardo" wrote:

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

"Pamela" wrote:

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

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

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! :)

Formula
 

yes please,


"Pamela" wrote:

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

I could email you the spreadsheet.

"Eduardo" wrote:

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

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

"Eduardo" wrote:

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

"Pamela" wrote:

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

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

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! :)

Formula
 

on its way

"Eduardo" wrote:

yes please,


"Pamela" wrote:

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

I could email you the spreadsheet.

"Eduardo" wrote:

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

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

"Eduardo" wrote:

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

"Pamela" wrote:

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

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

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! :)

Formula
 

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

"Pamela" wrote:

on its way

"Eduardo" wrote:

yes please,


"Pamela" wrote:

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

I could email you the spreadsheet.

"Eduardo" wrote:

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

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

"Eduardo" wrote:

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

"Pamela" wrote:

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

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

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! :)

Formula
 

ok, thanks.

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

let me know if you have any luck.

"Eduardo" wrote:

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

"Pamela" wrote:

on its way

"Eduardo" wrote:

yes please,


"Pamela" wrote:

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

I could email you the spreadsheet.

"Eduardo" wrote:

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

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

"Eduardo" wrote:

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

"Pamela" wrote:

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

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

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! :)