Shared workbook

blean1 · Mar 27th, 2002, 06:54 AM

I've looked, but can't find what I'm looking for. Short version: Old boss leaves, leaves behind a shared workbook everybody uses. Can be improved. I wish to do so for new boss, but of course a whole slew of options unavailable. Like conditional formatting. (This thing is more a template than a spreadsheet) How do I get around this? Thanks,
Bill

Ian Mac · Mar 27th, 2002, 06:57 AM

Goto: Tool>Share Workbook and uncheck the 'Allow change by more than one user' box, this should un-share the book for you.

Mar 27th, 2002, 06:57 AM	#2
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	Goto: Tool>Share Workbook and uncheck the 'Allow change by more than one user' box, this should un-share the book for you. __________________ "Have a good time......all the time" Ian Mac

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

Mar 27th, 2002, 06:54 AM	#1
blean1 New Member Join Date: Mar 2002 Posts: 12	I've looked, but can't find what I'm looking for. Short version: Old boss leaves, leaves behind a shared workbook everybody uses. Can be improved. I wish to do so for new boss, but of course a whole slew of options unavailable. Like conditional formatting. (This thing is more a template than a spreadsheet) How do I get around this? Thanks, Bill