First, thank you for telling me about the graphics. I didn't
realize that. Regarding the links, I appreciate the direction, but it's
not a matter of finding the links. I know where they are. I want them
broken. I do not want to be questioned about whether or not I want to
update them on a daily basis when I open my gradebook. I use it
everyday for keeping attendance and grades.
There is no reason to update the workbooks it's linked to. I keep
that information, because on rare occasion I've been questioned later in
the year about what grade a student had when they left me, because the
main attendance/grade database lost information and they needed to
regather it.
If anyone can tell me how to break the links I would be extremely
grateful.
Thank you.
Elaine

Hello-
Open the file and go to EditLinks, select them all from the list and click
the Break Link button.

HTH |:)



On 9/24/05 3:06 PM, in article , "thelees"
wrote:


First, thank you for telling me about the graphics. I didn't
realize that. Regarding the links, I appreciate the direction, but it's
not a matter of finding the links. I know where they are. I want them
broken. I do not want to be questioned about whether or not I want to
update them on a daily basis when I open my gradebook. I use it
everyday for keeping attendance and grades.
There is no reason to update the workbooks it's linked to. I keep
that information, because on rare occasion I've been questioned later in
the year about what grade a student had when they left me, because the
main attendance/grade database lost information and they needed to
regather it.
If anyone can tell me how to break the links I would be extremely
grateful.
Thank you.
Elaine

Hi,
There is no break link button :-( I got scolded earlier because I'd
included graphics to show what I'm getting and break links isn't an option I
can find anywhere.
Elaine

CyberTaz wrote:

Hello-
Open the file and go to EditLinks, select them all from the list and click
the Break Link button.

HTH |:)

On 9/24/05 3:06 PM, in article , "thelees"
wrote:


First, thank you for telling me about the graphics. I didn't
realize that. Regarding the links, I appreciate the direction, but it's
not a matter of finding the links. I know where they are. I want them
broken. I do not want to be questioned about whether or not I want to
update them on a daily basis when I open my gradebook. I use it
everyday for keeping attendance and grades.
There is no reason to update the workbooks it's linked to. I keep
that information, because on rare occasion I've been questioned later in
the year about what grade a student had when they left me, because the
main attendance/grade database lost information and they needed to
regather it.
If anyone can tell me how to break the links I would be extremely
grateful.
Thank you.
Elaine

Sorry... I jumped in without testing the water because of the split post.

If you want to leave the links intact but not be prompted, you can go to
ToolsOptionsEdit and remove the check for prompting for link updates. You
can also select the cells, copy - but leave them selected, then use
EditPaste Special--Values. I believe there is also a
ToolsOptionsCalculation checkbox for 'Save external link values' which may
also do the job if you clear the checkbox.

Regards |:)




On 9/24/05 3:09 PM, in article ,
"CyberTaz" wrote:

Hello-
Open the file and go to EditLinks, select them all from the list and click
the Break Link button.

HTH |:)



On 9/24/05 3:06 PM, in article , "thelees"
wrote:


First, thank you for telling me about the graphics. I didn't
realize that. Regarding the links, I appreciate the direction, but it's
not a matter of finding the links. I know where they are. I want them
broken. I do not want to be questioned about whether or not I want to
update them on a daily basis when I open my gradebook. I use it
everyday for keeping attendance and grades.
There is no reason to update the workbooks it's linked to. I keep
that information, because on rare occasion I've been questioned later in
the year about what grade a student had when they left me, because the
main attendance/grade database lost information and they needed to
regather it.
If anyone can tell me how to break the links I would be extremely
grateful.
Thank you.
Elaine

Hi,
I used the Tools/Options/Edit and removed the ck box to prompt to update
links. Now it won't prompt-- it just tries to open the link and I get hung up
there because that link's been deleted. Even when I try to click OK, that open
dialog box just keeps coming up.
My mistake was not pasting values only, which was how I figure I got into
this mess to begin with. Too late now. I also when to the Calculation tab in
Tools/Options and removed the save external link values, and I still have the
same problem when opening.
I may pull my hair out over this one, yet. Any other suggestions?
Elaine

CyberTaz wrote:

Sorry... I jumped in without testing the water because of the split post.

If you want to leave the links intact but not be prompted, you can go to
ToolsOptionsEdit and remove the check for prompting for link updates. You
can also select the cells, copy - but leave them selected, then use
EditPaste Special--Values. I believe there is also a
ToolsOptionsCalculation checkbox for 'Save external link values' which may
also do the job if you clear the checkbox.

Regards |:)

On 9/24/05 3:09 PM, in article ,
"CyberTaz" wrote:

Hello-
Open the file and go to EditLinks, select them all from the list and click
the Break Link button.

HTH |:)



On 9/24/05 3:06 PM, in article , "thelees"
wrote:


First, thank you for telling me about the graphics. I didn't
realize that. Regarding the links, I appreciate the direction, but it's
not a matter of finding the links. I know where they are. I want them
broken. I do not want to be questioned about whether or not I want to
update them on a daily basis when I open my gradebook. I use it
everyday for keeping attendance and grades.
There is no reason to update the workbooks it's linked to. I keep
that information, because on rare occasion I've been questioned later in
the year about what grade a student had when they left me, because the
main attendance/grade database lost information and they needed to
regather it.
If anyone can tell me how to break the links I would be extremely
grateful.
Thank you.
Elaine

The findlink addin has lots of options. Did you try it?

thelees wrote:

First, thank you for telling me about the graphics. I didn't
realize that. Regarding the links, I appreciate the direction, but it's
not a matter of finding the links. I know where they are. I want them
broken. I do not want to be questioned about whether or not I want to
update them on a daily basis when I open my gradebook. I use it
everyday for keeping attendance and grades.
There is no reason to update the workbooks it's linked to. I keep
that information, because on rare occasion I've been questioned later in
the year about what grade a student had when they left me, because the
main attendance/grade database lost information and they needed to
regather it.
If anyone can tell me how to break the links I would be extremely
grateful.
Thank you.
Elaine

--

Dave Peterson

I went and tried after your post, but it made no difference. This is Excel
2000. At work I have the exact same problem. If you have any other
suggestions, I'd be anxious to hear them.
Elaine

Dave Peterson wrote:

The findlink addin has lots of options. Did you try it?

thelees wrote:

First, thank you for telling me about the graphics. I didn't
realize that. Regarding the links, I appreciate the direction, but it's
not a matter of finding the links. I know where they are. I want them
broken. I do not want to be questioned about whether or not I want to
update them on a daily basis when I open my gradebook. I use it
everyday for keeping attendance and grades.
There is no reason to update the workbooks it's linked to. I keep
that information, because on rare occasion I've been questioned later in
the year about what grade a student had when they left me, because the
main attendance/grade database lost information and they needed to
regather it.
If anyone can tell me how to break the links I would be extremely
grateful.
Thank you.
Elaine

--

Dave Peterson

Hmmm.

One of the options in findlink is to delete the link (replace it with the
value).

That didn't work?

And one of the options was to just convert the links to values with no messages.

That didn't work either?

thelees wrote:

I went and tried after your post, but it made no difference. This is Excel
2000. At work I have the exact same problem. If you have any other
suggestions, I'd be anxious to hear them.
Elaine

Dave Peterson wrote:

The findlink addin has lots of options. Did you try it?

thelees wrote:

First, thank you for telling me about the graphics. I didn't
realize that. Regarding the links, I appreciate the direction, but it's
not a matter of finding the links. I know where they are. I want them
broken. I do not want to be questioned about whether or not I want to
update them on a daily basis when I open my gradebook. I use it
everyday for keeping attendance and grades.
There is no reason to update the workbooks it's linked to. I keep
that information, because on rare occasion I've been questioned later in
the year about what grade a student had when they left me, because the
main attendance/grade database lost information and they needed to
regather it.
If anyone can tell me how to break the links I would be extremely
grateful.
Thank you.
Elaine

--

Dave Peterson

--

Dave Peterson

I went back and clicked on Tools/Add-Ins.... An Add-Ins dialoge box opened with
Add-Ins available: At the bottom was Update Add-in Links. It was checked. All of
the options were already checked.

When I click on it and select Browse... an open dialogue box comes up with
Sound-Proof in an AddIns folder. When I drop the arrow, I see that the path for
this AddIns folder is: Windows/Application Data/Microsoft/AddIns.

If I go to Tools and Update AddIn Links.... A little Update AddIn Links dialogue box
opens. The radio button is in Active document (or there is a choice for All open
documents). If you click OK, nothing discernable happens. When I close and reopen,
it still prompts to update links.

There are no choices, so it didn't seem as though I was doing anything wrong. I
don't know about or see anywhere any of the options you referred to.

Elaine

Dave Peterson wrote:

Hmmm.

One of the options in findlink is to delete the link (replace it with the
value).

That didn't work?

And one of the options was to just convert the links to values with no messages.

That didn't work either?

thelees wrote:

I went and tried after your post, but it made no difference. This is Excel
2000. At work I have the exact same problem. If you have any other
suggestions, I'd be anxious to hear them.
Elaine

Dave Peterson wrote:

The findlink addin has lots of options. Did you try it?

thelees wrote:

First, thank you for telling me about the graphics. I didn't
realize that. Regarding the links, I appreciate the direction, but it's
not a matter of finding the links. I know where they are. I want them
broken. I do not want to be questioned about whether or not I want to
update them on a daily basis when I open my gradebook. I use it
everyday for keeping attendance and grades.
There is no reason to update the workbooks it's linked to. I keep
that information, because on rare occasion I've been questioned later in
the year about what grade a student had when they left me, because the
main attendance/grade database lost information and they needed to
regather it.
If anyone can tell me how to break the links I would be extremely
grateful.
Thank you.
Elaine

--

Dave Peterson

--

Dave Peterson

You can either install the Findlink.xla addin or just use file|open to be able
to use it.

I don't load it as an addin--I just do a file|open when I need it.

After it's open (either way), look under Tools, you'll find "Find Links". Click
on that. And you'll see what the options are.

ps. If you've installed Findlink.xla as an addin, you should see:
Find/delete links
in the tools|addins dialog.


thelees wrote:

I went back and clicked on Tools/Add-Ins.... An Add-Ins dialoge box opened with
Add-Ins available: At the bottom was Update Add-in Links. It was checked. All of
the options were already checked.

When I click on it and select Browse... an open dialogue box comes up with
Sound-Proof in an AddIns folder. When I drop the arrow, I see that the path for
this AddIns folder is: Windows/Application Data/Microsoft/AddIns.

If I go to Tools and Update AddIn Links.... A little Update AddIn Links dialogue box
opens. The radio button is in Active document (or there is a choice for All open
documents). If you click OK, nothing discernable happens. When I close and reopen,
it still prompts to update links.

There are no choices, so it didn't seem as though I was doing anything wrong. I
don't know about or see anywhere any of the options you referred to.

Elaine

Dave Peterson wrote:

Hmmm.

One of the options in findlink is to delete the link (replace it with the
value).

That didn't work?

And one of the options was to just convert the links to values with no messages.

That didn't work either?

thelees wrote:

I went and tried after your post, but it made no difference. This is Excel
2000. At work I have the exact same problem. If you have any other
suggestions, I'd be anxious to hear them.
Elaine

Dave Peterson wrote:

The findlink addin has lots of options. Did you try it?

thelees wrote:

First, thank you for telling me about the graphics. I didn't
realize that. Regarding the links, I appreciate the direction, but it's
not a matter of finding the links. I know where they are. I want them
broken. I do not want to be questioned about whether or not I want to
update them on a daily basis when I open my gradebook. I use it
everyday for keeping attendance and grades.
There is no reason to update the workbooks it's linked to. I keep
that information, because on rare occasion I've been questioned later in
the year about what grade a student had when they left me, because the
main attendance/grade database lost information and they needed to
regather it.
If anyone can tell me how to break the links I would be extremely
grateful.
Thank you.
Elaine

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson