Excel Calculating Data Tables when set to "Automatic Except for Data Tables"


New Member
Jan 6, 2015
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.


Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...