Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functioning of formulas
Hello
I would like to know why some times my formulas don't work and 5 mins. after they do. Do you have an explanation for this problem. Thank you for your answer. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functioning of formulas
Hi,
sometimes what happens is that you spreadsheet is in calculation mode, and it takes a few minutes to display the formulas. I guess your spreadsheet have lots of formulas "Denise" wrote: Hello I would like to know why some times my formulas don't work and 5 mins. after they do. Do you have an explanation for this problem. Thank you for your answer. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functioning of formulas
On Aug 20, 6:29*am, Eduardo wrote:
Hi, sometimes what happens is that you spreadsheet is in calculation mode, and it takes a few minutes to display the formulas. I guess your spreadsheet have lots of formulas "Denise" wrote: Hello I would like to know why some times my formulas don't work and 5 mins. after they do. *Do you have an explanation for this problem. Thank you for your answer.- Hide quoted text - - Show quoted text - I have that problem sometimes with a slow computer. If I scroll the formula off the page and back on again I find it has updated on the screen. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functioning of formulas
Hi Denise,
If the formulas don't work, goto Tools/Options/Calculation and check calculation method. Select Automatic. Keep also a eye on the statusbar, if calculate appears on the statusbar means that the sheet has bo ve calculated but the automatic option is not enabled. You can calc the sheet by pressing <F9. A last thing to keep in mind is that macros can change the calculation settings - Application.Calculation = xlCalculationManual - Application.Calculation = xlCalculationAutomatic Sometime this is used to speed up the macro if the sheet/workbook contains a lot of formulas. If the calculation is not re-enabled by the macro, you will back in manual calculation. Wkr, JP "Denise" wrote in message ... Hello I would like to know why some times my formulas don't work and 5 mins. after they do. Do you have an explanation for this problem. Thank you for your answer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do my formulas quit functioning in Excel 2007? | Excel Worksheet Functions | |||
F2 key is not functioning properly | Excel Discussion (Misc queries) | |||
It formulated, but it's not functioning | Excel Discussion (Misc queries) | |||
cells functioning odd | Excel Worksheet Functions | |||
Function Mal-Functioning | Excel Worksheet Functions |