Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using Excel 2003 and have my calculations set to automatic, but I notice
that there are times when my formulas do not calculate. If I click into the offending cell and hit "enter," esentially re-submitting the formula, it calculates. Since I am dealing with a large workbook with may worksheets worth of interdependent formulas, I am worried that my data will be inaccurate. Is there a limit to how many calculations an excel workbook can do and have I reached it? Is there a way I can force a cell to calculate even though there is nothing wrong with the formula, possibly with some vba code or something? I appreciate any help since my credibilty at work depends on presenting accurate data, and I have a real lack of confidence in what excel is giving me. Thanks, L.B. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Calculate Not Working in some Spreadsheets - Excel 2003 | Excel Worksheet Functions | |||
How do you calculate cotangent in Excel 2003? | Excel Worksheet Functions | |||
Excel 2003 Macro to re-calculate until... | New Users to Excel | |||
How do I calculate cells across Excel 2003 workbooks? | New Users to Excel | |||
Excel 2003 -- I need to know how to calculate a percentage of uni. | Excel Discussion (Misc queries) |