Excel 2003 Shared Workbook
Discussion
Anyone know if it possible to share an excel document amongst multiple users, but when saving, avoid "Resolve conflicts" and allow both users data to be saved but in seperate rows?
Users are adding new rows of data all the time, but sometimes 2 people try at the same time, and end up with the "resolve conflicts" message, meaning one's data is deleted.
I'm sure i've seen a solution to this somewhere, but can;t find it.
Thanks
Andy
Users are adding new rows of data all the time, but sometimes 2 people try at the same time, and end up with the "resolve conflicts" message, meaning one's data is deleted.
I'm sure i've seen a solution to this somewhere, but can;t find it.
Thanks
Andy
Agreed that Excel is not the tool you want - however, as you say, Access is not an option.
One option - though a bit over-engineered - would be to have a master sheet from which users open a copy, do their work and then "submit" this. This open-and-submit would be done in VBA, and you'd build in your own conflict resolution in this process (if that makes sense).
Not ideal by any means.
One option - though a bit over-engineered - would be to have a master sheet from which users open a copy, do their work and then "submit" this. This open-and-submit would be done in VBA, and you'd build in your own conflict resolution in this process (if that makes sense).
Not ideal by any means.
andy6581 said:
sjg said:
Excel is not for this. You want a database. Access would do at a pinch if it's a few users, if it's going to be any bigger then make the leap to a proper database.
I know access would be the solution, but most of the users only have word and excel. Not ideal 
but only 2 or 3 can write aswell (all based on their username under Active Directory)
if the OP does not want to use Access because of licence costs
how about OpenOffice Base
Landlord said:
Agreed that Excel is not the tool you want - however, as you say, Access is not an option.
One option - though a bit over-engineered - would be to have a master sheet from which users open a copy, do their work and then "submit" this. This open-and-submit would be done in VBA, and you'd build in your own conflict resolution in this process (if that makes sense).
Not ideal by any means.
Thanks! Yes i understand this. It looks like the only option really. I need to hand this over, and don;t want to ever have to support it so i need to look at whether it;s worth it One option - though a bit over-engineered - would be to have a master sheet from which users open a copy, do their work and then "submit" this. This open-and-submit would be done in VBA, and you'd build in your own conflict resolution in this process (if that makes sense).
Not ideal by any means.
I did try using userforms, with a save on submit in the vba, but it only works if it is saved whilst no one else has the sheet open.
Man-At-Arms said:
andy6581 said:
sjg said:
Excel is not for this. You want a database. Access would do at a pinch if it's a few users, if it's going to be any bigger then make the leap to a proper database.
I know access would be the solution, but most of the users only have word and excel. Not ideal but only 2 or 3 can write aswell (all based on their username under Active Directory)
if the OP does not want to use Access because of licence costs
how about OpenOffice Base
andy6581 said:
Man-At-Arms said:
andy6581 said:
sjg said:
Excel is not for this. You want a database. Access would do at a pinch if it's a few users, if it's going to be any bigger then make the leap to a proper database.
I know access would be the solution, but most of the users only have word and excel. Not ideal but only 2 or 3 can write aswell (all based on their username under Active Directory)
if the OP does not want to use Access because of licence costs
how about OpenOffice Base
change your IT Policy
Landlord said:
Man-At-Arms said:
won't allow free software ?
change your IT Policy
I dunno - they're going to have to, therefore, offer phone support for all sorts of software if they did that.change your IT Policy
Unfortunately, what i'm trying to help with here would not take priority, therefore the developers can't reallly provide a solution using sql/asp (at least not this century!), which is probably the approach i would have taken.
I'm trying to help a standard user , with some IT knowledge, provide a local solution using the tools they have available to them on their desktops.
And i've pretty much failed.
Edited by andy6581 on Wednesday 7th April 13:23
FlossyThePig said:
A simple excel solution is to apply a little bit of discipline.
Before adding a row the user should save the spreadsheet. This will apply any changes made by others.
Add the new row with minimum detail and save again (this should reserve the row).
Complete the details and save.
I'd argue that, "in the real world", discipline is rarely followed and often rejected in favour of "getting stuff done".Before adding a row the user should save the spreadsheet. This will apply any changes made by others.
Add the new row with minimum detail and save again (this should reserve the row).
Complete the details and save.
Landlord said:
FlossyThePig said:
A simple excel solution is to apply a little bit of discipline.
Before adding a row the user should save the spreadsheet. This will apply any changes made by others.
Add the new row with minimum detail and save again (this should reserve the row).
Complete the details and save.
I'd argue that, "in the real world", discipline is rarely followed and often rejected in favour of "getting stuff done".Before adding a row the user should save the spreadsheet. This will apply any changes made by others.
Add the new row with minimum detail and save again (this should reserve the row).
Complete the details and save.
#PS.. i just changed my username from andy6581 . It's still me
Edited by Aviz on Wednesday 7th April 14:40
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff