Constant Cell calculation updating

[Guest]

My spreadsheet constantly recalculates. On the bottom left of the screen it
says "Calculating Cells 0%", followed by "Calculating Cells 100%." This
loops over and over, making it difficult to do any work. I do have macroes
but I don't believe this has anything to do with it as I've been using the
same macros for a while. Also I use bloomberg API, but have been for a while
without any problems. Again the reculate has nothing to do with any data
on the spreadsheet (ie nothing on the page changes with these calculations.)
I have my calculate (under tools, options, calculate) set to automatic. Does
anyone know of any possible solutions to this? Thanks a lot!

 

[Dave O]

Your spreadsheet may have a macro that performs a re-calc every time a
particular spreadsheet event occurs. It may be set up to occur when
you enter or leave a particular cell or particular range of cells, for
instance.

You can check this by pressing ALT-F11 to open the VBA editor. In the
Project pane along the left margin of your screen, find the VBAProject
associated with your spreadsheet name. There is an icon tree for each
tab in the workbook, and for the workbook: right click on each icon and
click View Code- this is where event macros are stored. The event
triggers will be called something like SelectionChange, Change,
Deactivate, etc. Look for the command Calculate, and investigate the
source and rationale for that macro.