[mso] Re: excel- formula auditing
- From: "Ray Blake" <ray@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 24 Oct 2003 08:04:35 +0100
Rohit,
A couple of ideas for you, both based on the assumption that any link
will be to a file with a .xls extension.
1. Do a search (CTRL+F) for ".xls"
2. Create a conditional format for all cells to change the background
colour when that cell's formula contains the same string.
Ray
_____________
This email is from Ray Blake, Head of Software Design, GR Business
Process Solutions. It is confidential and intended for the addressee
only. The contents are private and may be legally privileged. If you
receive this email in error we would be grateful if you would advise the
sender and delete the email from your system.
For more information on the services that we offer please visit us at
our website: - www.grbps.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of rohit.kumar_gnc@xxxxxxxxx
Sent: 24 October 2003 07:50
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: excel- formula auditing
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
*************************************************************
*************************************************************
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:
