links...

laurajean100

New Member
Joined
Feb 16, 2002
Messages
8
Why is it not possible to 'Change Source'
within a file, to the file itself? ...AND
how can I edit the links to be self-referencing? (in 97 SR-1)
This message was edited by laurajean100 on 2002-02-17 16:56
This message was edited by laurajean100 on 2002-02-17 17:17
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
it is possible on xl 97, i'm pretty sure also for xl2000 but don't know about later versions. just click on the browse button in the edit links window and find the file name that way.
 
Upvote 0
in Edit, Links, Change Source, when I try to
select the file from within, I get an error
message 'Cannot access ***.xls'.
 
Upvote 0
well, that's a neat wizard, however:
Wizard
INTERNAL LINK LOCATION
Defined Name Links: None Found
Hidden Name Links: None Found
Microsoft Query Links: None Found
Object Links: None Found

When I open CopyOf***.xls the external links
persist! what other types of links ARE
there? apparently there is a macro to search
out the links to manually deleter them (?)
This message was edited by laurajean100 on 2002-02-18 09:06
 
Upvote 0
Laura,

I have this problem too. Know what I resorted to ? I made a file on my desktop called links.xls with "delete me" written in cell A1, sheet 1. Then when you get a dubious link request on opening a spreadhseet, just edit those links to pointing at this desktop file cell A1. If they ever turn up properly they will say "delete me" in the cell, although if you don't want that just then move sheet 1 from "links.xls" into your current worksheet, effectively moving the external link back into the open spreadhseet. Crazy, eh ?
 
Upvote 0
Ah, to be macro-proficient...
"just edit those links..."
Oh sure, I don't even know where the heck
those links are! I think I could edit them
if they would just show themselves instead of hiding like little cowards!

This is the type of thing I've been doing,
and will probably continue to do.
"move sheet 1 from "links.xls" into your current worksheet, effectively moving the external link back into the open spreadhseet. Crazy, eh ?"
you betcha!
Heeeere little external links, c'mere.
I don't want to hurt you... :wink:

thanks!
 
Upvote 0
nice

if you goto "edit" then "links" you will get a table of any external links..... then pick the one that looks like being from Neptune and you can click on "change scource".. this is what I've been doing to my desktop "links.xls" file
 
Upvote 0
OK, maybe I overstated my ignorance. I do
know about Edit/Links... You have got me
wondering if there is a way to hunt out the
culprit cells/chart series/etc. within my worksheet so that I can manually edit them. (?)

thanks, Chris!
 
Upvote 0
yeah.... using that edit links facility, point them now to your desktop file you created, pointing to its cell A1 which contains "delete me"

then, if they are kosher, they'll turn up with "delete me" visible and you can delete them or edit them

if after time they don't, just move the sheet 1 from your desktop file into your current file to make the link internal rather than external, saving your current file but not saving changes to your desktop file

eventually, all those link prompts will disappear, and you will see "delete me" peppered throughout your spreadsheets with which you can edit them back to planet earth

:)
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,938
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top