Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Constant Cell calculation updating
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Constant Cell calculation updating
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell Change Color - Need Help | New Users to Excel | |||
How do I fill down keeping one cell calculation from changing in . | Excel Discussion (Misc queries) |