Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Linked Sheets not updating automatically | New Users to Excel | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
Linked worksheets | Excel Discussion (Misc queries) |