Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am getting this message ONLY when I QUIT Excel (2000) with this 1 workbook
open: "Your formula contains an invalid external reference to a worksheet." If I simply close the workbook (without quitting Excel) the error does not appear. I have Googled the Excel newsgroups and tried these solutions to no avail. 1. FINDLNK. This shows no external links. 2. Unmerge every cell in the workbook and rerun FINDLNK. Nothing. 3. Set Application.DisplayAlerts = False in the workbook_beforeclose event hoping to just by pass the message. No good. 4. Searched for renamed sheets. I renamed a sheet from '7' to '8' about the time this started happening. No links found for '7' Now for the weird one: 5. I tried setting breakpoints in the workbook_beforeclose to find the line of code that was failing. It DOES NOT FAIL with a breakpoint set! This behavior appeared in this workbook about 5 revisions ago (out of 100+). Last note: this does NOT happen on a machine running WINXP/EXCELXP. I am running Win2K SP-4 and Excel2000 SP-3. I really need this message to go away in order to automate this program while I'm gone. It's my stock trading program. Any ideas will be greatly appreciated. Terry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External link lag | Excel Worksheet Functions | |||
External Link Issue | Excel Discussion (Misc queries) | |||
External link | Excel Worksheet Functions |