LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Freezing a cell value

Help desperately required.

I have a spreadsheet that takes a collection of user inputs to generate a
value that managers in my org will use as a guide to providing promotional
increases to employees. However, managers have the flexibility to choose a
different value if they want and so directly below the calculated cell value
is a free cell that managers can make their actul recommendation in.

Only trouble is.....this free cell is linked to some of the original
variable inputs that created the original input and so, depending on what
value the managers choose to enter, the original recommendation can change
and I don't want that.

So, problem of the day is as follows:- is there any way in excel to freeze a
cell value once it has been calculated for the first time so that any further
changes to input variables will not change the answer?

Many thanks
 
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
freezing a cell or cells doug Excel Worksheet Functions 2 February 23rd 07 12:28 PM
freezing cell values anthony Excel Worksheet Functions 1 May 10th 05 05:42 PM
Freezing one cell aliciarene Excel Worksheet Functions 2 March 19th 05 02:02 PM
Cell locking and program freezing sbmjm Excel Discussion (Misc queries) 0 February 22nd 05 07:49 PM
Freezing a cell range JMorrell Excel Discussion (Misc queries) 3 December 3rd 04 06:09 PM


All times are GMT +1. The time now is 10:26 PM.

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

About Us

"It's about Microsoft Excel"