[Shared] Workbook not behaving?

AJ · May 2nd, 2002, 03:43 AM

Hi everyone,

I've just been emailed a workbook from someone that I need to extract data from and it's obviously been Shared on their system. However, when I go to Tools>Share Workbook I cannot untick the box to removed the Shared status of the workbook (box is greyed out). Any ideas on how to sort this?

Many thanks
AJ

gareth · May 2nd, 2002, 04:03 AM

AJ

Did you try to save it on your desktop and changing the settings from there

AJ · May 2nd, 2002, 04:06 AM

Sorry mate, don't quite get you.
What difference does it make if the file is on the desktop? The box is still greyed out when I open the file.

Have I missed the point?

Rgds
AJ

AJ · May 7th, 2002, 09:39 AM

Hi everyone,
Thought I'd throw this one back up to see if gareth or anyone else has any ideas (Coz I'm still stuck!)

Many thanks
AJ

Mudface · May 7th, 2002, 10:44 AM

It sounds like the workbook has been 'protected and shared'- try going to Tools- Protection- Unprotect Shared Workbook, you may also need a password.

If not, make sure you have checked the box to 'Allow changes by more than one user' on the 'Editing' tab of the Tools- Share Workbook dialog box.

AJ · May 7th, 2002, 10:52 AM

Nice one Mudface - that's sorted the blighter!

May 2nd, 2002, 04:03 AM	#2
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	AJ Did you try to save it on your desktop and changing the settings from there __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

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

May 2nd, 2002, 03:43 AM	#1
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Hi everyone, I've just been emailed a workbook from someone that I need to extract data from and it's obviously been Shared on their system. However, when I go to Tools>Share Workbook I cannot untick the box to removed the Shared status of the workbook (box is greyed out). Any ideas on how to sort this? Many thanks AJ

May 2nd, 2002, 04:06 AM	#3
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Sorry mate, don't quite get you. What difference does it make if the file is on the desktop? The box is still greyed out when I open the file. Have I missed the point? Rgds AJ

May 7th, 2002, 09:39 AM	#4
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Hi everyone, Thought I'd throw this one back up to see if gareth or anyone else has any ideas (Coz I'm still stuck!) Many thanks AJ

May 7th, 2002, 10:44 AM	#5
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	It sounds like the workbook has been 'protected and shared'- try going to Tools- Protection- Unprotect Shared Workbook, you may also need a password. If not, make sure you have checked the box to 'Allow changes by more than one user' on the 'Editing' tab of the Tools- Share Workbook dialog box.

May 7th, 2002, 10:52 AM	#6
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Nice one Mudface - that's sorted the blighter!