Sign in to follow this  
Followers 0
nekrosoft13

Excel "File in Use" not showing.

7 posts in this topic

Hello

At my work (Canon) I noticed a slight problem with Excel, a group of people (5-10) use the same excel file, which they update from time to time. When one person opens the file, and then another person tried to open the file, there should be a "File in Use" message showing, with options Read-only and Notify. Well the problem is that not every person gets that message. To be specific 4 people never get that message. How can this be fixed, so every one would get File in Use message.

Btw some computers are windows 2000 with Excel 2000 sp3, and some are Windows xp with Excel 2002 Sp3.

Note: problem is not system specific, few 2000 and few xp are affected.

Thanks

Share this post


Link to post
Share on other sites

Odd that some see the message and not others...

I take it that this is not a shared workbook.

Is it always the same four users that don't see it - do they never see it or only sometimes?

Share this post


Link to post
Share on other sites

its the same 4 people that never get the message, on any workbook, thats already opened.

Share this post


Link to post
Share on other sites
its the same 4 people that never get the message, on any workbook, thats already opened.

586074671[/snapback]

Sorry... One more question! Do they gain access to write to the file or is it read only mode just without a warning?

I have looked through the options for both Excel versions and there is nothing to supress the message so maybe it is to do with their individual permissions on the file... Try reseting these to the same as a user who does receive the warning (do one at a time).

Share this post


Link to post
Share on other sites

they don't can't write to it, and there is no warning

Share this post


Link to post
Share on other sites
they don't can't write to it, and there is no warning

586093980[/snapback]

Did you try resetting their permissions for these files?

If this doesn't work then the file must be corrupt in some way - still odd that it doesn't affect everyone though!

Try creating a copy of the book by copying the sheets (right click on one of the sheet tabs, select all sheets, right click on one of the sheet tabs again, Move or copy, create copy [tick box] in new book [drop down]). Save the file and give it a go...

If this doesn't work then I have no idea...

Share this post


Link to post
Share on other sites

i will try that

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.