?
Solved

Reserved by 'user name' message appears when opening Excel 2007 File

Posted on 2010-01-12
6
Medium Priority
?
5,427 Views
Last Modified: 2012-05-08
I have a user that sees reserved by bob message when working with an Excel 2007 file. User also wants to change the password, but then it says reserved by bob. How can remove the password and not have Excel show 'reserved by' message?

Thanks,

Paul
0
Comment
Question by:gtrapp
  • 2
  • 2
  • 2
6 Comments
 

Expert Comment

by:MBrooks
ID: 26295970
Someone probably has the Excel file open right now.
Go to Tools --> Share Workbook --> Remove user
0
 
LVL 3

Assisted Solution

by:mediabrand
mediabrand earned 800 total points
ID: 26295973
Is it only on one particular file?

If so - try saving it as a different file somewhere else, with a different name.  Then restart Excel and try changing the password again.
0
 

Author Comment

by:gtrapp
ID: 26296029
Go to Tools? I am in Office 2007. I don't see Tools as a menu selection. What do I select?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Accepted Solution

by:
MBrooks earned 1200 total points
ID: 26296111
Right, sorry.

Click the 'Review tab'.
In the 'Changes' group, click the 'Share Workbook' button.
From the 'Who has this workbook open now' list, select the name of the user who you want to disconnect.
Click the 'Remove User' button.
0
 
LVL 3

Expert Comment

by:mediabrand
ID: 26296118
On the Review tab > Share Workbook.  Choose the user and then remove.
0
 

Author Comment

by:gtrapp
ID: 26362924
What if the "Remove User" button is grayed out? Is this a file permissions issue?
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question