These are all good suggestions - this gives me a good idea of how to avoid
this problem in future. Share Workbook still isn't available, so I may just
have to rebuild the file - thanks for your help!

"Dave Peterson" wrote:

This is a guess...

The developer of that workbook may have not wanted you to share that file and
disabled that option.

You could try this to see if it enables that option.

Tools|Customize|toolbars tab
select the worksheet menu bar
click reset

You will lose any other changes to that toolbar, though.

Then try tools|share workbook
to see if it's available.



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