| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
freezing data in a cell which was obtained using a formula
I am using Excel as a form. Upon initial opening of form, I am generating a
Random interger that once generated, I would like to freeze on that excel sheet as a tracking # in a cell. My problem is that Excel keep recalculating that cell each and every time the spread sheet opens. Is there any way to freeze date in cell after a formula calculate the initial number? The excel sheet will be saved individually using that Random interger. This is to track the Excel sheet forms. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlighting cells if a value is obtained | Excel Discussion (Misc queries) | |||
| Excel 2003 freezing when changing a cell or adding new data | Excel Discussion (Misc queries) | |||
| Using cell reference in a formula instead of the obtained value | Excel Worksheet Functions | |||
| transform hour data obtained from access database to decimal | Excel Discussion (Misc queries) | |||
| Freezing the cell (with Random formula) | Excel Discussion (Misc queries) | |||
Threaded Mode
