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?
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).
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!
I know this is a really old posting, but I wanted to add what I just found
because I think anyone having this problem may find it helpful.....
You CANNOT share a work book that has a list. First you must convert the
list to a range DATA, LIST, CONVERT TO RANGE. Then you can share the work
book.
I know this is a really old posting, but I wanted to add what I just found
because I think anyone having this problem may find it helpful.....
You CANNOT share a work book that has a list. First you must convert the
list to a range DATA, LIST, CONVERT TO RANGE. Then you can share the work
book.
I have been working with a shared workbook that had a number of lists. Decided to do some maintenance and now it won't go back to shared. Why do you think it was allowed to be shared in the first place when it had lists in it?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.