Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Recalculations Excel 2002 (xp)
I am curious to how others are hangling the following problem. I have a number of users that are unable to perform a recalculation on there spreadsheets (via shift + F9 or tools\optionscalculations\calc sheet) When you have a spreadsheet set up for manual calculations( ie. Tools\options\calculations\manual) the worksheet does not recalculate. Using F9 from that point will not recalculate the spreadsheet either. (of course all this is dependent on cell changes / updates) . Now, this being said, if you use F9 to recalculate the spreadsheet from the beginning then the spreadsheet recalculates properly and shift+f9 works from that point. Also should a new formula be added to the worksheet Prior to using shift + F9, the recalculations work. With all this being said, I have found that you can also save the spreadsheet in html format and reopen /save in excel and the issue disappears. I am presently looking for a configuration or fix i can push to these individuals machines that could fix this issue. Any suggestions or other ideas? Thanks!! -Z -- zen2010 ------------------------------------------------------------------------ zen2010's Profile: http://www.hightechtalks.com/m139 View this thread: http://www.hightechtalks.com/t2270507 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |