cells protected when trying to link

gideon · May 13th, 2002, 05:50 PM

Hi,

I'm trying to create a simple link from one workbook to another and when I try to do this I cannot click the target cell. Any ideas on why this is happening?

Cheers

NateO · May 13th, 2002, 06:02 PM

I've seen this in very large workbooks, glitch. Try clicking on a different cell and clicking over to the cell (using arrows) or manually re-writing the formula. You should still be able to grab the data.

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-13 17:04 ]

gideon · May 13th, 2002, 06:04 PM

Yes, thanks......I did that work around...

Any idea what causes it, is it a memory thing?

NateO · May 13th, 2002, 06:05 PM

That's my guess, seeing as I've only noticed it with the very large workbooks. I suspect it has more to do with Excel's interpretation of RAM than Windows though.

Yogi Anand · May 13th, 2002, 06:07 PM

Quote:

On 2002-05-13 16:50, gideon wrote:
Hi,

I'm trying to create a simple link from one workbook to another and when I try to do this I cannot click the target cell. Any ideas on why this is happening?

Cheers

Perhaps the sheet has the EnableSelection Propert of the sheet turned off.

Chances are the sheet is protected, and the developer has featured the EnableSelection property xlNoSelection
two other options are xlNoRestrictions, and
xlUnlockedCells

_________________
Yogi Anand
Edit: Deleted inactive web site reference from hard code signature line

[ This Message was edited by: Yogi Anand on 2003-01-19 17:15 ]

NateO · May 13th, 2002, 06:48 PM

Good thinking Yogi.

Not in my case, but perhaps in Gideon's. I think in my case the file ended up being corrupted.

_________________
Cheers, NateO

[ This Message was edited by: nateo on 2002-05-13 17:51 ]

May 13th, 2002, 06:05 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	That's my guess, seeing as I've only noticed it with the very large workbooks. I suspect it has more to do with Excel's interpretation of RAM than Windows though. __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

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

May 13th, 2002, 05:50 PM	#1
gideon Board Regular Join Date: Mar 2002 Posts: 78	Hi, I'm trying to create a simple link from one workbook to another and when I try to do this I cannot click the target cell. Any ideas on why this is happening? Cheers

May 13th, 2002, 06:02 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	I've seen this in very large workbooks, glitch. Try clicking on a different cell and clicking over to the cell (using arrows) or manually re-writing the formula. You should still be able to grab the data. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-13 17:04 ]

May 13th, 2002, 06:04 PM	#3
gideon Board Regular Join Date: Mar 2002 Posts: 78	Yes, thanks......I did that work around... Any idea what causes it, is it a memory thing?

May 13th, 2002, 06:48 PM	#6
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Good thinking Yogi. Not in my case, but perhaps in Gideon's. I think in my case the file ended up being corrupted. _________________ Cheers, NateO [ This Message was edited by: nateo on 2002-05-13 17:51 ]