Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

Updating links

Posted by Barrie Davidson on April 27, 2001 12:23 PM

I have a file with links. When I select Edit,Links from the menu bar I cannot select the Manual Update option (the radio button).

Does anyone know why this selection might be greyed out??

Thx, Barrie

Re: Updating links

Posted by Kevin James on April 27, 2001 12:37 PM

Hi Barrie,

I just now looked at a linked file I keep. Here is what I found. If I open the master form, the one that actually links, the option is available. However, if I close it and open one of the dependent files, the option is greyed out. Either the links no longer exist the file you are opening or it is not the master.

Re: Updating links

Posted by Barrie Davidson on April 27, 2001 2:51 PM

Thanks for the response Kevin. This doesn't seem to be the problem here. I tried making a very simple linked file, cell A1 linked to cell A1 in another file. Both files only contain data in cell A1. I STILL CANNOT CHANGE THE OPTION TO MANUAL UPDATE!!! Very frustrating...any other ideas.

Re: Updating links

Posted by Dave Hawley on April 27, 2001 11:36 PM

Hi Barrie

This option is only for linked Objects between Applications eg; a Chart in Word or Powerpoint.

Dave
OzGrid Business Applications

Thanks Dave

Posted by Barrie Davidson on April 30, 2001 12:57 PM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.