Excel 2003 Share Workbook problem

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

shek

Thread Starter
Joined
Jul 11, 2006
Messages
6
An excel file is stored on a server and is used by sevral users simultaneously.
Users found that the file they using is not synchronized SOMETIMES.
i.e. user A add a record and then save, user who viewing the same file at same time save the file and find nothing is added!

Have you met the same problem before?
Are there any patch for Excel 2003?
PLEASE HELP ME~~~
THANKS~!
 

OBP

Joined
Mar 8, 2005
Messages
19,895
As you haven't received any other responses to your post, can I ask you a question?
Have you got Access?
 
Joined
Jul 25, 2004
Messages
5,458
Depending on the size of your organization, you may want to think about possibly integrating SharePoint Server. If your company is already utilizing that application, you have the tools necessary to do so. SPS 2007 also has a handy check-out/check-in feature as well.

HTH
 

shek

Thread Starter
Joined
Jul 11, 2006
Messages
6
Thanks OBP and firefytr replys.

OBP, I'm not sure, but at most case the users are using Office 2003 Professional.
So I think they should have Access 2003 installed.

firefytr, sorry to tell you that the comany for which I severed have no SPS.
The file just stored on a sever, and user just share the excel file by enabling the "Share Workbook" function.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
shek, if you want to convert the Excel workbook to an Access database, whcih does support proper file sharing then let me know.
 
Joined
Jul 25, 2004
Messages
5,458
I agree with OBP that this would probably be easier in Access. Some companies are so anti-solution, they may not allow an Access transition. If this is the case, you can check if the file is open on the local machine or over a network with some VBA.

HTH
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top