Formula


P

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

Advertisements

E

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
 
P

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

Pamela

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

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, ??
 
Ad

Advertisements

P

Pamela

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

I could email you the spreadsheet.
 
E

Eduardo

yes please,
(e-mail address removed)

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

I could email you the spreadsheet.
 
E

Eduardo

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

Advertisements

P

Pamela

ok, thanks.

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

let me know if you have any luck.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top