Bad link. crashes excel when cell touched

jberry216 · Apr 17th, 2002, 06:35 AM

I have one cell. It is is linked to another sheet in the same workbook. The link is corrupted in some way, as it is returning "old" data. However, when I try to change, delete, or type over the cell, excel freezes and I have to end task intask manager. Any ideas?

Iain Lewis · Apr 17th, 2002, 06:49 AM

Have you tried selecting an adjacent cell and then dragging the cursor over ?
In the bottom right corner of the activecell there is a small black square. If you hover the mouse over this square it should cahnge to a black cross. Hold down the left mouse button and drag the activecell over the problem cell.
It should clear the cell reference & hopefully solve your problem.

jberry216 · Apr 17th, 2002, 07:24 AM

Hi Iain: Tried all of that stuff. I am still hanging up. Thanks for the idea though.

Joe

MarkHenri · Aug 10th, 2002, 10:47 AM

Send me the spreadsheet and I'll try opening it in XL2002. It's error recovery is very good and if there's a problem in the spreadsheet, it'll usually fix it. Also, give me your version so I can send it back in the correct format.

Also, try copying the worksheet into a new workbook and see if it still happens there. Also try Excel in safe mode and see if the problem goes away. To run Excel in safe mode, click on Start | Run and type 'excel /s' (without the quotes) and press OK. If it works, Excel has minor configuration problems.

Since you get two free support calls with the Office suite, you could call Microsoft Support at 425-635-7056 for assistance also.

Jack in the UK · Aug 10th, 2002, 10:51 AM

Hi Mark

Can i ask, recovery is good in XP, but looses Macros, do you have a fix to this??

Cheers mate

Mark O'Brien · Aug 10th, 2002, 10:57 AM

Seriously, Mark, this question was posted in April.

What is you point here?

Jack in the UK · Aug 10th, 2002, 10:59 AM

MOB its JackLand

Check you PM

Aug 10th, 2002, 10:47 AM	#4
MarkHenri Board Regular Join Date: Aug 2002 Posts: 106	Send me the spreadsheet and I'll try opening it in XL2002. It's error recovery is very good and if there's a problem in the spreadsheet, it'll usually fix it. Also, give me your version so I can send it back in the correct format. Also, try copying the worksheet into a new workbook and see if it still happens there. Also try Excel in safe mode and see if the problem goes away. To run Excel in safe mode, click on Start \| Run and type 'excel /s' (without the quotes) and press OK. If it works, Excel has minor configuration problems. Since you get two free support calls with the Office suite, you could call Microsoft Support at 425-635-7056 for assistance also. __________________ <font size="-1">Mark Henri</font> <font size="-2">Microsoft Tier 1 Excel Support Technician</font>

Aug 10th, 2002, 10:51 AM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Mark Can i ask, recovery is good in XP, but looses Macros, do you have a fix to this?? Cheers mate __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Aug 10th, 2002, 10:57 AM	#6
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Seriously, Mark, this question was posted in April. What is you point here? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Aug 10th, 2002, 10:59 AM	#7
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	MOB its JackLand Check you PM __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 06:35 AM	#1
jberry216 New Member Join Date: Feb 2002 Location: Houston, TX Posts: 14	I have one cell. It is is linked to another sheet in the same workbook. The link is corrupted in some way, as it is returning "old" data. However, when I try to change, delete, or type over the cell, excel freezes and I have to end task intask manager. Any ideas?

Apr 17th, 2002, 06:49 AM	#2
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Have you tried selecting an adjacent cell and then dragging the cursor over ? In the bottom right corner of the activecell there is a small black square. If you hover the mouse over this square it should cahnge to a black cross. Hold down the left mouse button and drag the activecell over the problem cell. It should clear the cell reference & hopefully solve your problem.

Apr 17th, 2002, 07:24 AM	#3
jberry216 New Member Join Date: Feb 2002 Location: Houston, TX Posts: 14	Hi Iain: Tried all of that stuff. I am still hanging up. Thanks for the idea though. Joe