Linked sheets - URGENT!
 

Hi,

I've having a little problem.

I copied some data from one workbook into a new one.

Now, everytime I go into my new workbook, its comes up with a dialog
box saying;

'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 workbooks?'

and gives you the options, Yes or No.


Is there anyway to unlink/disable/turn off this link so I don't keep
getting the diaglog box?


Any advice would be much appreciated.

Thanks,

M


--
Muppet
------------------------------------------------------------------------
Muppet's Profile: http://www.excelforum.com/member.php...o&userid=10989
View this thread: http://www.excelforum.com/showthread...hreadid=313731

Hi
goto: http://oaltd.co.uk/MVP/Default.htm

and search for Findlink.zip
(http://oaltd.co.uk/DLCount/DLCount.a...e=FindLink.zip)


"Muppet" wrote:


Hi,

I've having a little problem.

I copied some data from one workbook into a new one.

Now, everytime I go into my new workbook, its comes up with a dialog
box saying;

'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 workbooks?'

and gives you the options, Yes or No.


Is there anyway to unlink/disable/turn off this link so I don't keep
getting the diaglog box?


Any advice would be much appreciated.

Thanks,

M


--
Muppet
------------------------------------------------------------------------
Muppet's Profile: http://www.excelforum.com/member.php...o&userid=10989
View this thread: http://www.excelforum.com/showthread...hreadid=313731

open the linked file
then gp to EditLinksStatup Prompt
and select "Do not diplay alerts...

"Muppet" wrote in message
...

Hi,

I've having a little problem.

I copied some data from one workbook into a new one.

Now, everytime I go into my new workbook, its comes up with a dialog
box saying;

'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 workbooks?'

and gives you the options, Yes or No.


Is there anyway to unlink/disable/turn off this link so I don't keep
getting the diaglog box?


Any advice would be much appreciated.

Thanks,

M


--
Muppet
------------------------------------------------------------------------
Muppet's Profile:
http://www.excelforum.com/member.php...o&userid=10989
View this thread: http://www.excelforum.com/showthread...hreadid=313731

Check through all the formulas in the sheet, there is likely to be 1
that references the first sheet. It will most likely be encased with []
type brackets.


--
PeterG
------------------------------------------------------------------------
PeterG's Profile: http://www.excelforum.com/member.php...o&userid=16485
View this thread: http://www.excelforum.com/showthread...hreadid=313731