Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding problem source causing "Your formula contains an invalid external reference to a worksheet" message
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding problem source causing "Your formula contains an invalid external reference to a worksheet" message
Scrap that!
The file just needed to be closed and re-opened. I guess Excel got confused. Cheers Chrisso |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding problem source causing "Your formula contains an inval
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. "Chrisso" wrote: Scrap that! The file just needed to be closed and re-opened. I guess Excel got confused. Cheers Chrisso |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error "invalid data source reference" for pivot table | Excel Worksheet Functions | |||
Invalid external reference message | Excel Discussion (Misc queries) | |||
"A formula in worksheet contains 1 or more invalid references?" | Charts and Charting in Excel | |||
Clear Form results in INCORRECT "Invalid Property" message.... | Excel Programming | |||
Formula Contains an invalid external reference to a worksheet | Setting up and Configuration of Excel |