ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Share Workbook command is not available (greyed out) (https://www.excelbanter.com/excel-discussion-misc-queries/84187-re-share-workbook-command-not-available-greyed-out.html)

BB

Share Workbook command is not available (greyed out)
 
Further clarifications:

For those suggesting solutions, the following are NOT factors:
*The document is not opened (Readonly).
*We have write access to the shared drive where the document resides,
and to the document
*The creator of the document has not prevented (at least knowingly) or
restricted access in any way.
*The fact that the document was not created by the person attempting to
turn on sharing is not a factor. This is not a restriction on other
documents not created by the person invoke sharing.

It appears that there is some feature used in this spreadsheet which
then renders it unsharable, so the "Share Workbook" feature is turned
off and not available to be selected. Otherwise, we are doing nothing
different from other previously shared workbooks of a similar nature.
The only factors different in my case is that there are some more
complex features in use (Lists, functions, etc.) than in some other
shared workbooks.

Any solution to this question would be most appreciated!


Bryan Hessey

Share Workbook command is not available (greyed out)
 

Are there Lists created in this workbook?


BB Wrote:
Further clarifications:

For those suggesting solutions, the following are NOT factors:
*The document is not opened (Readonly).
*We have write access to the shared drive where the document resides,
and to the document
*The creator of the document has not prevented (at least knowingly) or
restricted access in any way.
*The fact that the document was not created by the person attempting
to
turn on sharing is not a factor. This is not a restriction on other
documents not created by the person invoke sharing.

It appears that there is some feature used in this spreadsheet which
then renders it unsharable, so the "Share Workbook" feature is turned
off and not available to be selected. Otherwise, we are doing nothing
different from other previously shared workbooks of a similar nature.
The only factors different in my case is that there are some more
complex features in use (Lists, functions, etc.) than in some other
shared workbooks.

Any solution to this question would be most appreciated!



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534523


BB

Share Workbook command is not available (greyed out)
 
Hi Bryan, yes, there are Lists. That is one of the features that
differentiates this workbook from others I have shared in the past.

Brian



All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com