
Alt+F11 to open the VBA editor.
Tools > References
Check for references listed as Broken. That means that such file is not on this machine.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Microsoft Visual Basic Run-time error '-2147024809 (80070057)': Reference isn't valid.
Alt+F11 to open the VBA editor.
Tools > References
Check for references listed as Broken. That means that such file is not on this machine.
@JEO PALENCIA
@Tom van Stiphout Your reply didn't work for me. I finally figured out it was because of broken hyperlinks. Here's an easy fix.
In my case, I had to reformat the text that was no longer linked, but I no longer had the "Reference isn't Valid" error.
An alternative is to cut the cells, past them somewhere else using the Paste Values option, which pastes the values as text. Now cut and paste them back where they were originally.