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

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 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

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