Hidden Links in my spreadsheet :: MrExcel Message Board


 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

Hidden Links in my spreadsheet
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

guntoter
Board Regular


Joined: 09 Nov 2002
Posts: 12


Status: Offline

 Reply with quote  

Hidden Links in my spreadsheet

I am using Excel 2000. I took several large spreadsheets and combined them into one Giant spreadsheet. However, since I did this, every time I open the spreadsheet I get that "Do you want to update the links to other spreadsheets" warning. It's annoying. I have spent loads of time trying to find this slippery link, but no luck.
How can you find all your links to other spreadsheets (so I can wipe them out)???

Post Mon Jul 07, 2003 10:04 pm 
 View user's profile Send private message MSN Messenger

LTunnicliffe
Board Master


Joined: 08 May 2003
Posts: 725
Location: Dallas, TX
Flag: Usa

Status: Offline

 Reply with quote  

Try searching your each sheet for ":\". Basically your looking for the C:\SubFolder\ part of the link. See if this helps!
_________________
Loren

The numbers don't lie, but sometimes they don't tell the whole truth.

Post Mon Jul 07, 2003 10:17 pm 
 View user's profile Send private message

kpuls
Board Master


Joined: 10 Jun 2003
Posts: 298
Location: Nanoose Bay, BC, Canada
Flag: Canada

Status: Offline

 Reply with quote  

Re: Hidden Links in my spreadsheet

If that doesn't work, the other place that I've found can hang you up is if you have any names defined in the Workbooks that you've copied from. You can check that out a couple of ways:

From your insert menu, choose Name. From here you can either:

1) Choose Define. Look for any name in the left hand side of the list that has a corresponding value in the right hand side. Chances are that if there is a value on the right, that it is to an external file. You will have to do this on each sheet, and make sure that you know where it is supposed to be going to so that you can re-establish the name if you delete it from your workbook completely.

or 2) Choose Paste, and paste a list of all the names in your worksheet. (Just make sure you have a blank area to do it.) This should show you where the names refer to external files, but you'll have to go back to (1) to delete them.

HTH,
_________________
Ken Puls, CMA

There is nothing I hate more than when my computer does what I tell it to, and not what I want it to...

Post Mon Jul 07, 2003 11:56 pm 
 View user's profile Send private message

pennysaver
Board Master


Joined: 15 May 2003
Posts: 2139
Location: San Diego, California
Flag: Usa

Status: Offline

 Reply with quote  

Re: Hidden Links in my spreadsheet

Guntoter,

This is a Delete Links Add-In from Microsoft that works pretty well.

http://support.microsoft.com/default.aspx?scid=kb;en-us;188449

Also, sometimes, you can go to Edit --> Links and change the linked file to the one you're working in. This points the formulas in the right direction.

Hope that helps,

Smitty

Post Tue Jul 08, 2003 12:04 am 
 View user's profile Send private message Visit poster's website MSN Messenger

guntoter
Board Regular


Joined: 09 Nov 2002
Posts: 12


Status: Offline

 Reply with quote  

Re: Hidden Links in my spreadsheet

Thank you all for the ideas. When I get to work tomorrow I will try them to see if I can find those little stinkers.

Thanks again.
Guntoter

Post Tue Jul 08, 2003 12:51 am 
 View user's profile Send private message MSN Messenger

guntoter
Board Regular


Joined: 09 Nov 2002
Posts: 12


Status: Offline

 Reply with quote  

Re: Hidden Links in my spreadsheet

Ken,
Your idea did it. I looked in the Defined Names of ranges, and, lo and behold, the little stinkers were hiding right amount the Named ranges that I created. I simply deleted all of the ones with #REF# as part of it's equation, and when I opened the spreadsheet the next time there were no link update messages. I didn't know excel would create it own ranges when you are manually merging several spreadsheets into one giant one, but it seems to have done just that.
Thanks again to all of you who answered.

Post Thu Jul 10, 2003 5:22 pm 
 View user's profile Send private message MSN Messenger
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.