MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Multiple User Access


Posted by Greg on February 13, 2002 4:42 AM

Hi all,

I need to put a spreadsheet on a network so employees can fill in
some target data. Probelm is only one person can write to the file
at a time. Is there a way around this?

Many thanks


Posted by Matt Rowe on February 13, 2002 5:18 AM

Have you tried going to Tools -> share workbook and clicking the allow more than one users check box? This should sovle your problem - you may also want to look at the advanced options that relate to data integrity also....
Cheers
Matt