| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculate
Calculate never goes away in the Status Bar. I have a rather small workbook
in which I've deleted all links to try and reduce the number of calculations. Each time I hit F9 or Ctrl-Alt-F9 the Status bar flashes 6% and then still Calculate. Any ideas? Thanks, Adam |
|
#2
|
|||
|
|||
|
http://support.microsoft.com/default.aspx?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References AdamMCW wrote: Calculate never goes away in the Status Bar. I have a rather small workbook in which I've deleted all links to try and reduce the number of calculations. Each time I hit F9 or Ctrl-Alt-F9 the Status bar flashes 6% and then still Calculate. Any ideas? Thanks, Adam -- Dave Peterson |
|
#3
|
|||
|
|||
|
Dave thanks for your response,
I've read this before and I may not be understanding what is meant by "formula references", but I have a hard time believing my Workbook has 65,536 formula references. Max I'd say it has 1,000. "Dave Peterson" wrote: http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References AdamMCW wrote: Calculate never goes away in the Status Bar. I have a rather small workbook in which I've deleted all links to try and reduce the number of calculations. Each time I hit F9 or Ctrl-Alt-F9 the Status bar flashes 6% and then still Calculate. Any ideas? Thanks, Adam -- Dave Peterson |
|
#4
|
|||
|
|||
|
I don't have another guess and it sure looks like it fits.
AdamMCW wrote: Dave thanks for your response, I've read this before and I may not be understanding what is meant by "formula references", but I have a hard time believing my Workbook has 65,536 formula references. Max I'd say it has 1,000. "Dave Peterson" wrote: http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References AdamMCW wrote: Calculate never goes away in the Status Bar. I have a rather small workbook in which I've deleted all links to try and reduce the number of calculations. Each time I hit F9 or Ctrl-Alt-F9 the Status bar flashes 6% and then still Calculate. Any ideas? Thanks, Adam -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions | |||
| Not able to calculate. | Excel Worksheet Functions | |||
| How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions | |||
Linear Mode
