WHY AM I GETTING THIS ERROR REFERENCE ISN'T VALID IN EXCEL SPREADSHEET

JEO PALENCIA 1 Reputation point
2021-03-29T17:08:08.34+00:00

Microsoft Visual Basic Run-time error '-2147024809 (80070057)': Reference isn't valid.

Microsoft 365 and Office | Excel | For business | Windows
Developer technologies | Visual Basic for Applications
{count} votes

2 answers

Sort by: Most helpful
  1. Tom van Stiphout 1,861 Reputation points MVP Volunteer Moderator
    2021-03-31T01:30:03.27+00:00

    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.

    0 comments No comments

  2. Kris Carlson 1 Reputation point
    2022-08-23T16:12:02.073+00:00

    @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.

    1. Select the cell, column, row, or sheet with the issue.
    2. Right click the selection.
    3. In the dropdown menu, select Remove Hyperlink(s).

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.