Corrupt cell data

TPL001 · May 20th, 2002, 12:23 AM

On one worksheet in a 2.5Mb file, with plenty of network links, data in about 10 cells can't be changed. When I try to alter the data, it shuts down Excel by producing an access error in a Dr Watson for NT display box. I can't even save the file to another location - it shuts down the file and Excel with the same error. Any ideas?

Tom Schreiner · May 20th, 2002, 12:43 AM

Hi TPL001.
I have had similiar extreme frustrations with the good ole "Access Violation" on NT.
I only wish I could offer you some specific reason on the why's. The only suggestion I can give, hopefully someone else can help you more, is to search Microsoft's knowledge base... If you wish, you can send me the file. If I can duplicate the error on my machine, I may be able to figure a fix. Have always managed a workaround in the past when I have run up against the NT wall.
I wish you success!
Tom

TPL001 · May 22nd, 2002, 05:01 PM

Tom,

Thanks for the sympathy. It does occur on other PCs, so the error is workbook dependant; hence, there is no point sending it to you, though I appreciate the offer. We have created another worksheet, replacing the problem one, but the error still remains. I am going to try and strip down the work book to eliminate possible causes.

Thanks again,
Troy.

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

May 20th, 2002, 12:23 AM	#1
TPL001 New Member Join Date: May 2002 Posts: 2	On one worksheet in a 2.5Mb file, with plenty of network links, data in about 10 cells can't be changed. When I try to alter the data, it shuts down Excel by producing an access error in a Dr Watson for NT display box. I can't even save the file to another location - it shuts down the file and Excel with the same error. Any ideas?

May 20th, 2002, 12:43 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi TPL001. I have had similiar extreme frustrations with the good ole "Access Violation" on NT. I only wish I could offer you some specific reason on the why's. The only suggestion I can give, hopefully someone else can help you more, is to search Microsoft's knowledge base... If you wish, you can send me the file. If I can duplicate the error on my machine, I may be able to figure a fix. Have always managed a workaround in the past when I have run up against the NT wall. I wish you success! Tom

May 22nd, 2002, 05:01 PM	#3
TPL001 New Member Join Date: May 2002 Posts: 2	Tom, Thanks for the sympathy. It does occur on other PCs, so the error is workbook dependant; hence, there is no point sending it to you, though I appreciate the offer. We have created another worksheet, replacing the problem one, but the error still remains. I am going to try and strip down the work book to eliminate possible causes. Thanks again, Troy.