| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel, multiply problem
I've done it a million times, taking the formula of a cell and copy that
formule to the rest of the sheet, to get the same calculation. suddenly it doesnt work and it just copies the value of the cell I copied, not the formalu, although it shows the formula in the cell! can anyone help me here. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel, multiply problem
Are they static references such as $A$1, if so it will calculate the same no
matter where you put it -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "hans" wrote: I've done it a million times, taking the formula of a cell and copy that formule to the rest of the sheet, to get the same calculation. suddenly it doesnt work and it just copies the value of the cell I copied, not the formalu, although it shows the formula in the cell! can anyone help me here. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel, multiply problem
ToolsOptionsCalculation.
Make sure you are set to "automatic". Gord Dibben MS Excel MVP On Thu, 18 Jan 2007 19:10:00 -0800, hans wrote: I've done it a million times, taking the formula of a cell and copy that formule to the rest of the sheet, to get the same calculation. suddenly it doesnt work and it just copies the value of the cell I copied, not the formalu, although it shows the formula in the cell! can anyone help me here. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing from Excel Sheet Problem | Excel Discussion (Misc queries) | |||
| Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| Excel 2007 Beta Setup Problem | Setting up and Configuration of Excel | |||
| Excel 2003 code, problem in Excel 97 | Excel Discussion (Misc queries) | |||
| Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
Linear Mode
