Multi user simultaneous use of excel..is it possible? URGENT

shivam71

New Member
Joined
Nov 28, 2005
Messages
1
Hi Experts,

I have a need to design an application which many users will use AT THE SAME TIME- TO QUERY , UPDATE DATA etc..

The question is that: IF MANY USERS ARE DOING UPDATES ETC AT THE SAME TIME, THEN IS IT POSSIBLE TO DO SO IN EXCEL?

I think that it is not possible but still I think I will check with experts first..

Is it possible with Access?

With thanks,
Nirav.
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

j844929

Active Member
Joined
Aug 18, 2002
Messages
423
You can have people updating the same the spreadsheet at once by sharing the workbook. You just have to be sure that no-one is going to overwrite data that someone else has entered (although the user will be warned if they enter data in a cell where someone else has saved something).

Go to Tools=>Share Workbook and then save it.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,521
Messages
5,572,625
Members
412,475
Latest member
JaredNAU
Top