View Single Post
  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default Share Workbook is grayed out in the Tools menu

And one (maybe better) guess.

When you look at the titlebar, do you see [Read-Only] after the workbook name?

If you do, then you have to open the file not in readonly mode.

That could mean to wait for another user to close the file

or it could mean that you could use windows explorer to change that readonly
property

or it could mean that you don't have write ability to the drive that holds that
file (you'll have to save it somewhere else first--or get the permissions
changed).



Alicia wrote:

I was able to use "Share Workbook" in a new file, but why would that function
not be available in the existing file? Is it because I didn't create it
originally? If I save it in a particular way, could I enable Share Workbook?

Thanks!

"Dave Peterson" wrote:

Is that option always greyed out? Or is just greyed out for this workbook?

Start a new workbook and test it out.

If it's always greyed out, you can try resetting that toolbar:

Tools|Customize|toolbars tab
select worksheet menu bar
click Reset

Did that work?


Alicia wrote:

Why is "Share Workbook" grayed out? What do I need to do differently to use
that function? I'm using MS Office Pro 2003


--

Dave Peterson


--

Dave Peterson