Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2014, 12:40 PM
ITSupportJourneyman ITSupportJourneyman is offline 'Another User' displaying when opening an excel file Windows 7 64bit 'Another User' displaying when opening an excel file Office 2010 32bit
Novice
'Another User' displaying when opening an excel file
 
Join Date: Jan 2014
Location: USA
Posts: 1
ITSupportJourneyman is on a distinguished road
Question 'Another User' displaying when opening an excel file


Hi,

I am trying to find preventative solutions to resolve an issue when multiple people share an excel file.

What happens is when another person opens an excel file that has been open for a while it displays that the file is currently open by 'another user'.

The solution that I have on hand already is going into Computer Management on the server >> Shared Folders >> Open Files and being able to see who actually has the file locked out. Then notify the correct people.

Using the Excel sheet as a collaborative workbook is not an option, since our company policy doesn't allow it due to, to many of them in the past becoming corrupt.

This appears so far that the temporary lock file become corrupt.

Any help or suggestion on trying to prevent this from happening so no one needs to intervene every time this happens is appreciated.
Reply With Quote
  #2  
Old 01-28-2014, 06:15 PM
excelledsoftware excelledsoftware is offline 'Another User' displaying when opening an excel file Windows 7 64bit 'Another User' displaying when opening an excel file Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 453
excelledsoftware will become famous soon enough
Default

I think this has your answer.

http://www.ozgrid.com/forum/showthread.php?t=32949

Just adjust the time amount to how long you want it to "time out"
Reply With Quote
Reply

Tags
another user, corrupt files, locked excel file

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
'Another User' displaying when opening an excel file Displaying pictures from a field with a file path okiegirl Mail Merge 4 07-28-2012 02:14 AM
'Another User' displaying when opening an excel file Opening the CSV file in the Excel has two different appearances! Jamal NUMAN Excel 6 01-23-2012 12:55 PM
'Another User' displaying when opening an excel file User opening files in Excel 2003 andy Excel 3 05-03-2011 07:35 PM
User Name Prompt Appears When Opening Documents galleherjazz Office 0 07-30-2009 08:15 PM
File gets hanged up while opening in excel 2007 nvsudheer Excel 6 06-11-2009 05:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft