View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sander
 
Posts: n/a
Default formula displayed, not calculated

Hi,

I'm working on a sheet with a couple of others and something happened in
such away that formulas I enter are not calculated but displayed as formulas.

So formulas allready there are calculated but new ones are not. I've tried
CTRL + `
but no luck with that.

I've the basis =C1 to point to the value C1 and let it show up. On some
sheets this works, on others it doesn't. Also on the sheet where this works,
I cannot get a value from another sheet.

Any ideas??