Excel help with shared workbook

J

Jonny Two Shoes

Expert Member
Joined
Nov 13, 2006
Messages
4,542
Reaction score
17
Location
Gauteng
Hi there,

Quick one here hopefully. Does anyone know how I can share an excel workbook in such a way that if multiple users on the workbook make changes it does not ask which changes to keep or overwrite anything, instead it simply moves all changes made by one user to the next row so that nothing is lost and no notice messages show?. For instance if I work on a contact details list at the same time as someone else and we are both entering seperate details on the same row depending on who saves first it will simply move the other users info to the next line.

We are using Excel 2000 however I am sure this feature is supported I just don't know how to get it back and there are plenty of articles on tracking changes and sharing workbooks but they don't explain how to do what I am trying to do.

:) thanks
 
Last edited:
Maybe it has something to do with file permissions that allows one to edit but not overwrite any cells? Come on guys three forums have not replied to me including this one lol. :rolleyes: It's the name isn't it. Come now be honest :p
 
You say that but the users are complaining that the function was there before and when sharing and security permissions were changed because of an internal audit that function was lost. So now I am wondering how the heck they set it up before?
 
Jonny Two Shoes said:
Hi there,

Quick one here hopefully. Does anyone know how I can share an excel workbook in such a way that if multiple users on the workbook make changes it does not ask which changes to keep or overwrite anything, instead it simply moves all changes made by one user to the next row so that nothing is lost and no notice messages show?. For instance if I work on a contact details list at the same time as someone else and we are both entering seperate details on the same row depending on who saves first it will simply move the other users info to the next line.

We are using Excel 2000 however I am sure this feature is supported I just don't know how to get it back and there are plenty of articles on tracking changes and sharing workbooks but they don't explain how to do what I am trying to do.

:) thanks
Click to expand...

It looks like you need a database solution. Of course you could ue Excel to access the DB via ODBC.
 
bekdik said:
It looks like you need a database solution. Of course you could ue Excel to access the DB via ODBC.
Click to expand...

HA!! :D now try telling a user that when they have been using the excel method for a good couple of years :p

Personally I would have used the database solution right from the start. But different strokes for different folks I guess.
 
^ Thanks :)

OK well Im not exactly a pro with excel and access as I don't use them much myself but what I have done so far may help if I can solve the rest.

I have been able to do a small test where I linked an access table with an excel file and if you add data in access and save and/or add data in excel and save it shows the input in both excel and access.

Now my only problem is that even if I share the excel document the second user who opens it only has read-only access on the excel file. Any idea why and how I can avoid this? I am hoping that if data is entered into the access database this way then it will solve my initial problem by getting the data from the access database rather than resolving the conflicts by overwriting them.

Any ideas?
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X