Shared workbook problem.

[st471438]

So,

I have this shared workbook some of some areas are protected and i have attached other word and excel documents on two of the columns so lets say M & N columns. Now when I protect and share it, users are not able to doubble click on those attachments and so they cant see those attached documents.
Is there anyway that I can accomplish this task? I know Excel have limitations in shared workbook. I am using Excel 2003.

Thank you.

 

[F&s anaylst]

Hi there,

unshare your workbook again, now select the that contain these attachments, go to format cells (Ctrl+1), go to the protection tab and uncheck the locked box.

now share your workbook again it should work now

 

[st471438]

Hi Kevin,

Thanks for your quick answer but it is still not working

 

[F&s anaylst]

Are these docs embedded into xls file or hyperlinked?

 

[st471438]

embedded into file.

 

[F&s anaylst]

sorry can't help you with that now (i ever use share workbook any more, i use sharepoint instead)

i will test it 2mara at work and see if i can figure it out, will let you know what happens

Regards

 

[xlfun4all]

If you are still searching for an answer to this, when you elect to Protect Sheet, below where it says "Allow all users of this worksheet to:", scroll down the list to the bottom and select "Edit Objects", then click "OK". I'm using Excel 2007, but if memory serves me correctly, the file protection window in 2003 is set up the same way. Hope that helps!