Hello All!
This has been bothering me for a while. I work with many large, data-heavy models. Many times I need to paste in values from outside files into these models to keep them up-to-date. When pasting values into these models, some function perfectly fine when the Workbook Calculation is set to "Automatic Except Data Tables". However, some models will randomly freeze and begin going through all the iterations and calculations and data tables when I paste in a value (it varies from every 10th value I paste to each and every time I paste one, there is no rhyme or reason), and I am positive that is is set on this proper Workbook Calculation setup (Iterations are always set to 100, if that helps).
Does anyone know why this happens? It drives me crazy!! Sometimes the workbooks will freeze up for many minutes at a time, so I'll just end up pasting in the data in Manual Calculation mode, but it makes it more difficult and tedious to check my work. The models all function fine, and I am just convinced some work better than others and I will just have to deal with it, but the fact that its doing the opposite of what my settings are set up as makes me thing there may be some other setting in excel I can tweak to fix the issue.
Thanks!
This has been bothering me for a while. I work with many large, data-heavy models. Many times I need to paste in values from outside files into these models to keep them up-to-date. When pasting values into these models, some function perfectly fine when the Workbook Calculation is set to "Automatic Except Data Tables". However, some models will randomly freeze and begin going through all the iterations and calculations and data tables when I paste in a value (it varies from every 10th value I paste to each and every time I paste one, there is no rhyme or reason), and I am positive that is is set on this proper Workbook Calculation setup (Iterations are always set to 100, if that helps).
Does anyone know why this happens? It drives me crazy!! Sometimes the workbooks will freeze up for many minutes at a time, so I'll just end up pasting in the data in Manual Calculation mode, but it makes it more difficult and tedious to check my work. The models all function fine, and I am just convinced some work better than others and I will just have to deal with it, but the fact that its doing the opposite of what my settings are set up as makes me thing there may be some other setting in excel I can tweak to fix the issue.
Thanks!
