Getting "Resize to show all values" in Excel

Discussion created by kpfonten on Dec 5, 2013
Latest reply on Aug 4, 2020 by bbregenzer

I am using "Sampled Data" to call data with an adjustable Start/End time that is entered using cells. When I change these times, the output cells are updated.  However, if the array is larger than it was previously, the bottom cells show "Resize to show all values".  This causes my formulas on the sheet to become invalid (#Value errors).  Is there a way to avoid this issue either with an excel/pi property or VBA code?