Finding problem source causing "Your formula contains an invalid external reference to a worksheet"

C

Chrisso

Hi there

I was deleting some rows on an old spreadsheet I have been asked to
work on when suddenly I am confronted with the following message:

"Your formula contains an invalid external reference to a
worksheet ... <snip>"

The menu item "Edit - Links" is greyed out and I have run a link
searcher (I found in this group) and cannot find any external links.

Is there way of finding the cell(s) that are causing the problem?

Chrisso
 
C

Chrisso

Scrap that!

The file just needed to be closed and re-opened. I guess Excel got
confused.

Cheers
Chrisso
 
J

JLGWhiz

To check and see if there is a worksheet change event that triggered the
message,
just right click on the worksheet tab at the bottom of the screen, then in
the pop-up menu box, click on view code. If you see code that starts with:

Private Sub Worksheet_Change()

Then that is the culprit. Otherwise, there was probably a formula in one of
the cells you deleted that referenced an external link and was triggered by
the delete event.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top