In excel formula auditing when i use trace dependents it shows thru arrows in which cell formula is entered that is dependent on the primary cell but it doesnt show where the primary cell is linked to other sheets in the same file or other files that are dependant on the primary cell. am i missing out something? this is important becoz there is a lot of financial data linked to one another and at times it is needed to delete a whole file then REF! gets created in other files. any suggestions/ tips welcome. rk ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************