LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Excel 2003 worksheet doesn't auto calculate

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Calculate Not Working in some Spreadsheets - Excel 2003 tmpotvin Excel Worksheet Functions 2 October 22nd 09 10:19 PM
How do you calculate cotangent in Excel 2003? mowgli Excel Worksheet Functions 2 April 23rd 08 12:09 PM
Excel 2003 Macro to re-calculate until... Dan New Users to Excel 4 June 2nd 06 06:35 PM
How do I calculate cells across Excel 2003 workbooks? mj New Users to Excel 2 February 17th 06 11:05 AM
Excel 2003 -- I need to know how to calculate a percentage of uni. Kelly Excel Discussion (Misc queries) 1 December 11th 04 03:10 PM


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"