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! |
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. |
All times are GMT +1. The time now is 03:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com