Reference Isn't Valid Excel Error - 6 Ways To Fix It
Excel triggers the “..Reference isn’t Valid” error when it cannot locate the cell or range you referenced. While this normally is the case, you will also run
Pivot Tables Visual Basic Reference Isnt Valid Isnt Valid Excel Error Button Formula Bar Reference Isnt Valid Excel Error
Source: technewstoday.com