You could have an event macro resize the rows/columns whenever the worksheet
recalculates. But be aware that these kinds of things will kill your edit|Undo
ability.

If you want to try, right click on the worksheet tab that should have this
behavior. Select view code and paste this into the code window:

Option Explicit
Private Sub Worksheet_Calculate()
Me.Rows.AutoFit
'or be specific
Me.Rows("1:33").AutoFit
End Sub

Rob E wrote:

I am trying to configure a worksheet to automatically adjust it's row heights
after the values have changed. Some of the formulas on the page are simply
pulling text off other cells in other tabs. When the text in those other tabs
is changed to a larger or smaller size, the row height on the original tab
changes, but not the row height on the sheet that has the formula, even
though both tabs have Automatic Row Height selectd.

--

Dave Peterson