LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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??


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible? DakotaNJ Excel Worksheet Functions 25 September 18th 06 09:30 PM
Formula in a cell instead of its calculated value!! excellimits Excel Worksheet Functions 2 February 14th 06 12:51 AM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
calculated value displayed in increments golden322 Excel Discussion (Misc queries) 1 January 25th 06 10:32 PM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 05:39 AM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"