New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Office For Mac Excel - False File Reservations


Post Reply New Thread Subscribe

 
Thread Tools
jvickers

 
Member Since: Jun 07, 2010
Posts: 3
jvickers is on a distinguished road

jvickers is offline
I've been searching on this issue for a while, and I wanted to see if anyone else was having similar issues and/or if there were any fixes.

Any time I open a particular Excel sheet (.xlsx format), I get the File Reservation window (the one that says "[This excel] is being modified by [Another User]. Open as Read-Only, or choose Notify to be alerted when it is available.")
The issue being that: *I* opened the file under that username, X days ago.
Some flag seems to be getting tripped that I can't remove, so Excel always thinks that this file is open and someone is editing it. This might not seem like a big problem, but the thing is I'm not the only one who can edit this file, so I can't just assume that no one has edited it since me, so any time I make changes, I have to save a new version. This amounts to many copies of this file, which is unnecessary and annoying to maintain.
Is anyone else seeing this issue? Is there a flag somewhere that I can remove?
QUOTE Thanks
EvenStranger

 
EvenStranger's Avatar
 
Member Since: Dec 09, 2010
Location: Virginia
Posts: 845
EvenStranger is just really niceEvenStranger is just really niceEvenStranger is just really niceEvenStranger is just really niceEvenStranger is just really nice
Mac Specs: Currently 13" Late 2010 MBA, 4GB/128GB; Early 2011 13" MBP, dual core i7 2.7ghz, 4gb ram, 500gb hd

EvenStranger is offline
If it's only affecting this one file, it might be worth recreating the file and deleting the original. If it's affecting multiple files, then it might be a permissions issue with the directory itself.
QUOTE Thanks
zgoalieman

 
Member Since: Jan 24, 2013
Posts: 1
zgoalieman is on a distinguished road

zgoalieman is offline
If you open Terminal and go to the folder where the file is located, enter "ls -la" and you'll see that there is a file with the same filename preceded by a tilda and dollar sign"~$". Delete that file and your problem is solved.

Use the following: rm "~\$filename" to delete the file.
QUOTE Thanks

Post Reply New Thread Subscribe


« A good free Finder/File batch renamer? | maps or roadmaps?? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Office 2004 (Excel specifically) install Boweevol Running Windows (or anything else) on your Mac 1 02-02-2010 09:22 PM
Not too pleased with new iMac JunMacTech Apple Desktops 14 12-05-2005 07:13 PM
File copying frustrations - help? djmitch Switcher Hangout 5 06-27-2005 01:23 AM
Can you guys open this site? Desolate One OS X - Apps and Games 13 04-29-2005 01:23 PM
excel macro + file vault = access problems southside Switcher Hangout 4 04-18-2004 01:42 PM

All times are GMT -4. The time now is 05:22 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?