Search

Language:  
Search for:

Available article translations:

Unable to open Excel file which is already in use by another user

APPLIES TO:
  • Parallels Desktop 8 for Mac

Symptoms

  • I am unable to open Excel file (which is located on network share) from Finder using 'Open with...' -> Microsoft Excel (Windows X) when the same file has been opened by another user (e.g. on Windows PC).

  • I get an error message "File in use"

Your text to link here...

Cause

Resolution

In order to solve this error you need to modify the file on the machine where it is already opened.

  1. In Microsoft Excel (2010) go to File -> Options -> Trust Center -> Trust Center Settings... -> Privacy Options -> disable option 'Remove personal information from file properties on save' -> Click OK.

  2. Open the Excel file (first instance). In Excel go to Review -> Share Workbook -> enable option 'Allow changes by more than one user at the same time. This also allows workbook merging.'

  3. Open the file (second instance) from another location.

Search words:

PD




1e5db16426987d561060acdf56d947b4 790d27220dd34433ff172f45c18cfb98 33c4522b6fa9ca8e050f19b889fb58f1

FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No