Forum Home
Press F1
Thread ID: 17827	2002-04-12 06:46:00	excel 2000 links	Guest (0)	Press F1

Post ID	Timestamp	Content	User
43464	2002-04-12 06:46:00	My spread sheet was once linked to another similar one, but now I don't need it to, I don't seem to be able to stop asking me if I 'want to update my info' when it starts up. Does anyone know if there is a tick I can put/take off someplace?	Guest (0)
43465	2002-04-12 13:35:00	I think it is Tools>Options>Calculations tab, then Uncheck Update Remote references. But I am not entirely sure. G P	Guest (0)
43466	2002-04-13 09:53:00	If you still haven't solved your problem and want to actually remove the link references in your worksheet you may need to get a free add-in that does the job. It's called FindLink.zip from www.bmsltd.co.uk To look for links from a workbook, install the add-in FINDLINK.XLA, activate the workbook and use Tools/Find Links and it will delete any references it finds after your confirmation. Works brilliantly.	Guest (0)
43467	2002-04-13 23:15:00	Well, Ive checked both of those ideas out now and the unchecking of 'update remote references' doesn't seem to do anything and also doesn't stay unchecked, when I open it again, Greham. Your site looked great, Susan, but the find links program didn't find any links! (cool program though, along with all the others) I'm thinking that the whole workbook, actually doesn't have any links anymore, but just says it does. I've deleted the file it supposedly links to, so I can't update even if I wanted to, and the 'update links manually' option is greyed out in edit>links. I've tried changing the source and see no differences... any other ideas??	Guest (0)
43468	2002-04-14 04:38:00	Well, Ive checked both of those ideas out now and the unchecking of 'update remote references' doesn't seem to do anything and also doesn't stay unchecked, when I open it again, Greham. Your site looked great, Susan, but the find links program didn't find any links! (cool program though, along with all the others) I'm thinking that the whole workbook, actually doesn't have any links anymore, but just says it does. I've deleted the file it supposedly links to, so I can't update even if I wanted to, and the 'update links manually' option is greyed out in edit>links. I've tried changing the source and see no differences... any other ideas??	Guest (0)
1