“Shared” excel ss blocking functions

Topic

New Reply

hey all. I posted a few weeks ago on being unable to sort correctly or set validations. There was no answer until I realized that the document is “shared”, which may mean it came off of my sharepoint originally. However, now it’s in my own drive, and it’s still reading shared.
Also, those postings are all missing, but I’ve reported this to an administrator, wondering if other people are experiencing missing posts in this new format.

thanks!

Reply | Quote

Replies

hey all. I posted a few weeks ago on being unable to sort correctly or set validations. There was no answer until I realized that the document is “shared”, which may mean it came off of my sharepoint originally. However, now it’s in my own drive, and it’s still reading shared.
Also, those postings are all missing, but I’ve reported this to an administrator, wondering if other people are experiencing missing posts in this new format.

thanks!

Do you mean the topic Cells don’t delete (2003)? No posts have been lost during the conversion to new software, as far as I know.

Reply | Quote

However, now it’s in my own drive, and it’s still reading shared.

The following text is copied from the Excel help topic Stop sharing a workbook

[*]Have all other users save and close the shared workbook. If other users are editing, they will lose any unsaved work.
[*]Unsharing the workbook deletes the change history. If you want to keep a copy of this information, print out the History worksheet or copy it to another workbook.
[*]On the Tools menu, click Share Workbook, and then click the Editing tab.
[*]Make sure that you are the only person listed in the Who has this workbook open now box.
[*]Clear the Allow changes by more than one user at the same time check box.
If this check box is not available, you must unprotect the workbook before clearing the check box.
[*]When prompted about the effects on other users, click Yes.

Reply | Quote