I've got an excel file, named quiz.xls.. it has 1 sheet, named sheet1. when i click the cell C3 it has a formula which is: =IF((B6='C:\EUDORA\Attach\
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
ive already search the entire hardisk but i still can't find any answercom.xls.. though i search it by answercom.xls, *.xls & answer still i cudn't find that excel.. but tnx anyway! =) was there a possiblity that answercom.xls at some point be renamed and mybe that's the reason why i cudn't find this file??
Its possible that answercom.xls has been renamed but finding it would be a case of trial and error.
It looks like quiz file C3 is checking that cell B6 has a corresponding answer in the missing answercom.xls A4, if true it returns 1, false it returns 0.
If thats the only linked cell in your quiz file then I wouldn't worry about finding answercom as you'll only need to find one answer elsewhere. To test if its the only linked cell, delete the cell, goto the 'Edit' menu and see if 'Links' has faded out. If the 'Links' menu is still bold you have other linked cells in quiz.xls. Hit undo to get your cell back.
To find all linked cells in the quiz file try John Walkenbachs's Pup program http://www.j-walk.com/ss/p
Good luck
Dave
Business Accounts
Answer for Membership
by: brettdjPosted on 2003-01-21 at 02:41:16ID: 7768851
At some stage with this excel file, somone has set up a link to Sheet1 A4 in an open workbook called answercom. The last time both files were open answercom resided in C:\EUDORA\Attach\
When the answercom workbook was closed this link updated itself in your current file to provide the full path name so that this file knew where to find answercom.xls
The EUDORA folder (and answercom file) were then either deleted, renamed or moved so now the link is dead. Try searching the PC for answercom.xls, you may still have the file