share workbook/sheet

[Steen]

Hi

I have a team of 8 people using a task list for daily opdate of status, work
done, estimation to complete, etc.. The wordbook uses several sheets and
macros.

What I would like was if it where possible to make a little application that
made i possible to select a specific row(s) an update specific field (fx in a
form). Wood that be possible? Could it be working just using "share wordbook"?

/Steen

 

[Dave Peterson]

You could use some built-in features of excel that may work ok.

In xl2003 and below, you can use Data|Form.
(try it on some test data)

And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

 

[Steen]

Hi Dave

Thanks for your answer.

I have not tried the hints yet, but will the use of forms help in the
ability to have concurrent users accessing the excelsheet?

/Steen

"Dave Peterson" skrev:

 

[Dave Peterson]

Nope.

But if you want concurrent users, you may find that excel is not the application
for you. Maybe using a real database program (Access??) would be a better fit.

 

[Steen]

Hi again Dave

Thanks again for your answer - dispite the fact that it was exacty what I
was a afraid off - I don't know any thing of databases...

What about using the Share function in Excell - any expirence with that?

/Steen

"Dave Peterson" skrev:

 

[Dave Peterson]

I've never used it in real life.

And there are lots of posts that describe problems with it.

If you decide to use it, make backups often.

Hi again Dave

Thanks again for your answer - dispite the fact that it was exacty what I
was a afraid off - I don't know any thing of databases...

What about using the Share function in Excell - any expirence with that?

/Steen

"Dave Peterson" skrev:

 

[Steen]

Hi Dave

Thanks for you answer and advice

I think I will look for another solution - might even end up buying a
solution (Scrum tool)...

/Steen

"Dave Peterson" skrev: