SysChat is a free online computer support community. Ask questions, share resources, contribute knowledge and discuss technology. Join our growing community to access all features. Register Now!

SysChat » Software Support » General Software » Where is the File open notification in Excel 2000?

General Software

Support and discuss general software, applications, utilities, tips etc.

Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old 08-16-2007, 03:19 PM
eschnepper eschnepper is offline
Junior Member
 
About:
Join Date: Aug 2007
Posts: 3
eschnepper is on a distinguished road

Default Where is the File open notification in Excel 2000?


I have a Windows 2003 server R2 Sp1 and XP SP2 workstations with Office 2000. Occasionally 2 users are able to access the same excel 2000 spreadsheet at the same time without receiving a file open notice until the second user tries to save the file. Then they receive a message stating that the file is in use and that they can do a save as. Usually if a user tries to access a file that is already in use, they receive a file in use popup and they are given the choice to open read only, notify or close. This issue does not happen all the time and is not specific to one particular file. And the file was never setup for sharing. I've checked my security and permissions for the shares and I don't see a solution. I've suspected file corruption and copied the data into a new file and replaced the old file thinking that would solve the problem and no luck. Is there something I'm missing?



Reply With Quote
  #2 (permalink)  
Old 08-17-2007, 06:45 AM
mhookem's Avatar
mhookem mhookem is offline
Moderator
 
About:
Join Date: Dec 2006
Location: Chesterfield, UK
Posts: 387
mhookem will become famous soon enoughmhookem will become famous soon enough

Page Excel Windows Server 2003


Hello, firstly I'd check the file permissions for the file that is on the server and the permissions of the users who are accessing the file.

Have you tried opening the file with three users?

Regards

Martin



Reply With Quote
  #3 (permalink)  
Old 08-17-2007, 09:24 AM
eschnepper eschnepper is offline
Junior Member
 
About:
Join Date: Aug 2007
Posts: 3
eschnepper is on a distinguished road

Default Where is the file open notification in Excel 2000


Thanks for the info. I have not tried 3 users, but the issue is not consistent so it is impossible to recreate the issue.

I'm starting to suspect some server 2003 updates that were installed through automatic updates to be the culprit. As they were the last change before the issue started occurring and since the error is inconsistent I'm having a hard time believing it's the permissions. I rebooted the server and I'm going to keep an eye on whether the issue still occurs (trying to rule out all outside factors). If so then I'll move on to your suggestion.



Reply With Quote
  #4 (permalink)  
Old 09-17-2007, 02:20 PM
Kakatal Kakatal is offline
Junior Member
 
About:
Join Date: Sep 2007
Posts: 1
Kakatal is on a distinguished road

Default Share the file


Open the file, Tools - Share Workbook. Editing Tab - check Allow Changes by more than 1 user at a time. Gets around the issue of the file being in use by 1 person.

HTH,
Kevin



Reply With Quote
  #5 (permalink)  
Old 09-17-2007, 02:27 PM
eschnepper eschnepper is offline
Junior Member
 
About:
Join Date: Aug 2007
Posts: 3
eschnepper is on a distinguished road

Default


Thanx for the info, but I think you're missing my point. I DON'T want 2 users to access a spreadsheet at the same time. The second user should receive a notification that the file is in use by another user and they are not receiving that notification and it doesn't say that they have a read only version of the file until they go to close the file.



Reply With Quote
  #6 (permalink)  
Old 09-23-2007, 11:13 PM
rosemaryjane rosemaryjane is offline
Junior Member
 
About:
Join Date: Sep 2007
Posts: 2
rosemaryjane is on a distinguished road

Default


I'm having the same issue with Excel 2003.

We don't have file sharing setup on the workbook.

I thought by default if one person has a workbook open and someone else tries to open it they'd get the Notify option, however this has stopped happening recently. Now when the customer goes to save they get prompted with a message saying the file has changed since they opened it and do they want to overwrite changes.

Is there a new hidden setting somewhere that I can switch on for the document asking it to notify on open if the file is in use?



Reply With Quote
  #7 (permalink)  
Old 09-27-2007, 12:28 AM
rosemaryjane rosemaryjane is offline
Junior Member
 
About:
Join Date: Sep 2007
Posts: 2
rosemaryjane is on a distinguished road

Default


Found the attached MS KB article, not sure if it works because I need to get our systems guys to OK it before trying it on a PC, but it looks promising.

You receive a "The file may have been changed" error message when you save a workbook to a network server in Excel 2002 or in Excel 2003



Reply With Quote
Reply





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use Windows XP Recovery Console jlacosta Windows 2 08-16-2011 02:47 AM
OST File Recovery and PST File Recovery Sami Backup and Data Recovery 1 09-07-2007 12:42 AM
.TIFF, JPEG, GIF: Photo files lingo and more eloisa_g Articles 0 05-30-2007 05:34 AM
Why My MS Office Files Do Not Open? computer data recovery Articles 2 04-09-2007 05:39 AM
Quick look at Popular Extensions dream_hunt General 0 08-06-2006 08:15 AM

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 Off
Pingbacks are Off
Refbacks are on



» Ads



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54