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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 02:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com