#1   Report Post  
Old July 31st 06, 09:31 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 33
Default Help needed

is there anyway you can see what links to other workbooks are associated with
the workbook you have open.

The problem i am having is when i open the workbook in question a message
appears and states "The workbook you opened contains automatic links to
information in another workbook. do you want to update this workbook with
changes made to the other workbook" Yes....... No. if i click No the workbook
opens, however if i click Yes the workbook just hangs and i have to go into
task manager to shut down the system. I can only assume that there is a
problem with one of the links.

ANY HELP PLEASE


  #2   Report Post  
Old July 31st 06, 09:40 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,594
Default Help needed

Bill Manville has written a utility, FindLink, for working with links. You
can get it at http://www.oaltd.co.uk/MVP/Default.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Monty" wrote in message
...
is there anyway you can see what links to other workbooks are associated

with
the workbook you have open.

The problem i am having is when i open the workbook in question a message
appears and states "The workbook you opened contains automatic links to
information in another workbook. do you want to update this workbook with
changes made to the other workbook" Yes....... No. if i click No the

workbook
opens, however if i click Yes the workbook just hangs and i have to go

into
task manager to shut down the system. I can only assume that there is a
problem with one of the links.

ANY HELP PLEASE





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sports Comp Ladder tabulating help needed shaunl Excel Worksheet Functions 12 January 29th 14 02:25 PM
Help needed! DBsWifeLB Excel Worksheet Functions 3 March 14th 06 09:23 PM
Vlookup Alternative Needed Rita Palazzi Excel Discussion (Misc queries) 3 March 2nd 06 05:14 PM
Little more help needed for my IF formula Greg Excel Discussion (Misc queries) 4 March 1st 06 12:16 AM
Custom percent format needed Will Fleenor Excel Worksheet Functions 1 June 29th 05 02:57 AM


All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017