Message


Main menu	Our service	Awards we've won	Find out about volunteering!	About Us	Feedback

Our origins	Our mascot	Top Experts of the Month!	Tell friends about us!	Link to us!	Disclaimer

Ask any question! Allexperts.com is the oldest & largest free Q&A service on the Internet

The commentator stephen stollmack posts about Defined Names on 4/3/01 10:58:10 PM

Message	Try this site: http://www.geocities.com/davemcritchie/excel/sheets.htm or any of the following threads at the WOPR Lounge EXCEL Board: http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=1044&Search=true&Forum=xl&Words=delete%20links&Match=And&Searchpage=0&Limit=25&Old=allposts&Main=696 or http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=14286&Search=true&Forum=xl&Words=delete%20links&Match=And&Searchpage=0&Limit=25&Old=allposts&Main=14273 or http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=8792&Search=true&Forum=xl&Words=delete%20links&Match=And&Searchpage=0&Limit=25&Old=allposts&Main=8676 or http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=8676&Search=true&Forum=xl&Words=delete%20links&Match=And&Searchpage=0&Limit=25&Old=allposts&Main=8676 or, if all else fails: 1.Select Edit, Links (If this command is not available, skip to step 3.) The Links dialog box will appear. 2.Click the Change Source button and change the link to the active file. 3.Select Insert, Name, Define. Scroll down the list in the Define Name dialog box and examine the "Refers to" box. Delete names that refer to another workbook or that contain an erroneous reference (such as #REF!). This is the most common cause of "phantom links." 4.Save your workbook. When you reopen it, Excel won't ask you to update links. Also check . . . . defined names; chart data; dialog boxes; hidden names (not accessible), use Namelist.exe from J-Walk.com [email protected]

The commentator Pat posts a message about Adding dashes on 4/5/01 11:57:32 AM

The commentator Aladin Akyurek posts about Adding dashes on 4/5/01 1:00:51 PM

The commentator Eric Chinn posts about Adding dashes on 4/5/01 11:08:26 PM

The commentator Michael Woodhouse posts a message about Assigning a Unique Value on 4/5/01 10:00:56 AM

The commentator Aladin Akyurek posts about Assigning a Unique Value on 4/5/01 11:23:21 AM

The commentator Scott Wescovich posts a message about Excel VBA and MS Query on 4/3/01 11:35:36 AM

The commentator Eric Chinn posts about Excel VBA and MS Query on 4/3/01 5:23:24 PM

The commentator Scott Wescovich posts about Excel VBA and MS Query on 4/4/01 9:56:43 AM

The commentator Eric Chinn posts about Excel VBA and MS Query on 4/4/01 10:57:29 AM

The commentator Scott Wescovich posts about Excel VBA and MS Query on 4/4/01 11:14:10 AM

The commentator Stephen Stollmack posts about Excel VBA and MS Query on 4/3/01 10:22:29 PM

The commentator Michael Woodhouse posts a message about My appologies on 4/3/01 10:04:16 AM

Gary Chernich posts a message about ADVICE - PIVOT TABLE PROBLEMS on 4/3/01 8:07:32 AM

Sam Alsop posts a message about Spread sheet stuff on 4/3/01 5:57:46 AM

The commentator stephen stollmack posts about Spread sheet stuff on 4/3/01 10:26:45 PM

The commentator Michael Woodhouse posts a message about Finding duplicates in a column on 4/2/01 3:01:48 PM

The commentator Eric Chinn posts about Finding duplicates in a column on 4/2/01 4:52:10 PM

The commentator Michael Woodhouse posts about Finding duplicates in a column on 4/3/01 10:40:49 AM

The commentator Michael Woodhouse posts a message about Formula for duplicated values on 4/2/01 2:07:58 PM

The commentator Aidan Heritage posts about Formula for duplicated values on 4/2/01 3:34:58 PM

The commentator Michael Woodhouse posts about Formula for duplicated values on 4/3/01 10:46:56 AM

Elizabeth Romero posts a message about Formulas on 4/2/01 12:48:18 PM

The commentator Aidan Heritage posts about Formulas on 4/2/01 3:37:38 PM

The commentator stephen stollmack posts about Formulas on 4/3/01 10:34:08 PM

Markus Gern posts a message about Connecting three or more sheets on 4/2/01 11:39:52 AM

The commentator stephen stollmack posts about Connecting three or more sheets on 4/3/01 10:36:19 PM

The commentator Steve posts a message about Defined Names on 4/2/01 11:04:52 AM

The commentator stephen stollmack posts about Defined Names on 4/3/01 10:58:10 PM

The commentator Steve posts about Defined Names on 4/4/01 8:31:08 AM

The commentator stephen stollmack posts about Defined Names on 4/4/01 7:51:32 PM

Click here to post a message

Click Here for Messages:

1 - 30 31 - 60

Like our site? Recommend us to your friends!

Newsletter Signup

Subscribe to ExperTease.
Enter name and email below!

Name
Email


Explore More on the AllExperts Network!
Arts/Humanities Autos Cities/Towns Comedy Computing/Technology Cultures Education Food/Drink Gadgets Games Health/Fitness Hobbies	Home/Garden Homework Help Industry Internet/Online Jobs/Careers Kids Money Movies Music/Performing Arts News/Issues Parenting/Family People/Relationships	Pets Real Estate Recreation/Outdoors Religion/Spirituality Science Shopping Small Business Sports Style Teens Travel TV/Radio

Hosted by www.Geocities.ws