ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unable to Share Workbook (https://www.excelbanter.com/excel-discussion-misc-queries/92406-unable-share-workbook.html)

Burnt

Unable to Share Workbook
 
I had orginally designated a workbook as shared. Now the workbook is no
longer designated as shared. To make matters worse, the "Share
Workbook" option in Tools is not available (it is shaded out). Did I
make an error in some setting?


JHalsall

Unable to Share Workbook
 

I am having a similar problem with a couple of my worksheets and can't
figure out a reason why it won't let me share these, any
ideas/solutions would be appreciated.

Thanks in advance.


--
JHalsall
------------------------------------------------------------------------
JHalsall's Profile: http://www.excelforum.com/member.php...o&userid=34382
View this thread: http://www.excelforum.com/showthread...hreadid=549122


JHalsall

Unable to Share Workbook
 

I have found the problem (via another thread) you cannot share a
workbook that contains lists (though excel doesn't tell you this), you
need to go through the workbook and select each list you have created
and either remove it or convert it to a range instead.


--
JHalsall
------------------------------------------------------------------------
JHalsall's Profile: http://www.excelforum.com/member.php...o&userid=34382
View this thread: http://www.excelforum.com/showthread...hreadid=549122



All times are GMT +1. The time now is 08:46 AM.

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