?
Solved

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

Posted on 2010-01-12
6
Medium Priority
?
5,018 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
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.

 

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

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!

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.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

765 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