• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

The Case of the Nonexistent User

Q1:When I try to open a shared workbook, Excel tells me it's already in use, but I'm certain it's not true.
A1: Excel might report that another user has a workbook open even though this is no longer true; in fact, you might see your own name more than once in the list of users. This situation occurs most often after a system crashes while the workbook is open. In this circumstance, select the user's name and click the Remove User button. If you see your own name listed twice, one of the listings is correct. If Excel won't let you remove one of these entries, try the other one.

Protection Is a Two-Step Process

Q1:I've created a shared workbook that contains multiple scenarios, but even after checking the Prevent Changes box, I find that other users are able to change my data.
A1: Protecting scenarios from inadvertent changes is a crucial step when you plan to share workbooks with other people, but these options are confusing if you don't understand how Excel protects workbooks. Checking the Prevent Changes box tells Excel you don't want anyone to be able to change or delete a given scenario. Checking the Hide box removes a scenario from the Scenario Manager, without removing the scenario itself. After enabling these options, however, you must turn on protection for your entire worksheet. Select Tools, Protection, Protect Sheet, and make sure the Scenarios box is checked in the Protect Sheet dialog box. Add a password if you want to prevent experienced but unauthorized users from overriding this option and making changes anyway.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint