A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Links cannot be updated message



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2004, 12:53 PM
Alan
external usenet poster
 
Posts: n/a
Default Links cannot be updated message

Hi,

When I open a particlar workbook the message below comes
up.

"This workbook contains one or more links that cannot be
updated.
* To change the source of links, or attempt to update
values again, click Edit Links.
* To open the workbook as is, click Continue."

I have checked all help/support sources and cannot find
the reason.

When I edit links and click check stsus its ok, when I go
to source its ok. I have checked all the links and they
are correct. The links are all automatic update
switched. Option for edit allow updating. They are
both .xls and not HTML.

I can find no apparent reason for this mesage to occur.

Any advice please?
  #2  
Old September 15th, 2004, 01:06 PM
JE McGimpsey
external usenet poster
 
Posts: n/a
Default

Download Bill Manville's FindLink.xla add-in. It can help you find any
link in your workbook (they can exist many places besides cells, e.g.,
defined names).

http://www.bmsltd.ie/MVP/




In article ,
"Alan" wrote:

Hi,

When I open a particlar workbook the message below comes
up.

"This workbook contains one or more links that cannot be
updated.
* To change the source of links, or attempt to update
values again, click Edit Links.
* To open the workbook as is, click Continue."

I have checked all help/support sources and cannot find
the reason.

When I edit links and click check stsus its ok, when I go
to source its ok. I have checked all the links and they
are correct. The links are all automatic update
switched. Option for edit allow updating. They are
both .xls and not HTML.

I can find no apparent reason for this mesage to occur.

Any advice please?

  #3  
Old September 15th, 2004, 01:45 PM
external usenet poster
 
Posts: n/a
Default

Thanks. It worked ...what a great little add-in!



-----Original Message-----
Download Bill Manville's FindLink.xla add-in. It can

help you find any
link in your workbook (they can exist many places

besides cells, e.g.,
defined names).

http://www.bmsltd.ie/MVP/




In article ,
"Alan" wrote:

Hi,

When I open a particlar workbook the message below

comes
up.

"This workbook contains one or more links that cannot

be
updated.
* To change the source of links, or attempt to update
values again, click Edit Links.
* To open the workbook as is, click Continue."

I have checked all help/support sources and cannot

find
the reason.

When I edit links and click check stsus its ok, when I

go
to source its ok. I have checked all the links and

they
are correct. The links are all automatic update
switched. Option for edit allow updating. They are
both .xls and not HTML.

I can find no apparent reason for this mesage to occur.

Any advice please?

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Express is slow ava cohen Outlook Express 18 August 27th, 2004 12:17 AM
error message - server rejecting recipient Ken Outlook Express 5 August 20th, 2004 06:39 PM
OE: ""OE has not yet downloaded this message" Emily Lin Outlook Express 4 August 6th, 2004 03:03 AM
trying to gain access to emails on old hard disk wilfred Outlook Express 2 July 13th, 2004 11:35 AM
Need vb method to handle: Links to 'AAA.xls were not updated because... Dave B Links and Linking 6 November 11th, 2003 05:48 AM


All times are GMT +1. The time now is 07:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.