[mso] Re: excel- formula auditing
- From: rohit.kumar_gnc@xxxxxxxxx
- To: mso@xxxxxxxxxxxxx
- Date: Fri, 24 Oct 2003 12:20:12 +0530
but even with the links, one cant see which cell has links and which cell
has not.
is there any short cut to fing out which cell has link to other sheet.
sometimes when i try to make a new file using an old file, most items are
copied and pasted special values but a few have formulas. in a large file
it becomes too tedious a thing to see which cell is left with links.
rk
"Linda F. Johnson"
<linda@personal-computer To:
<mso@xxxxxxxxxxxxx>
-tutor.com> cc:
Sent by: Subject: [mso] Re:
excel- formula auditing
mso-bounce@xxxxxxxxxxxxx
23-10-03 10:05 PM
Please respond to mso
The auditing toolbar only shows the precedents/dependents that are on the
same sheet
If you want to see links to other files that are referenced in your
formulas, go to the Edit menu and choose Links
Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of rohit.kumar_gnc@xxxxxxxxx
Sent: Thursday, October 23, 2003 8:55 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] excel- formula auditing
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
*************************************************************
*************************************************************
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
*************************************************************
Other related posts:
