Member Avatar for joekat

i have a problem with excel, i work in an organisation where our main data is stored in excel files. the problem is excel does not allow access to the file by multiple users. only the first person will be able to make and save changes, any other person who opens the file can only make changes but wont be able to save them at the end.

when he manages to save the changes, he will overwrite the changes made by the first person.

i need a way around this problem,

desperate, plz help
JoeKat

  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by pty
Member Avatar for pty

I need a way around this problem,

You have a problem because you are using a spreadsheet application for something that it was not designed to do. You should really be using a database.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.