Results 1 to 2 of 2

Thread: Input forms

  1. #1
    Join Date
    Apr 2004
    Location
    Singapore
    Posts
    5

    Red face Unanswered: Input forms

    Hi gang!

    Need help. I wonder if excel's forms can display and update information already captured in a worksheet? Also when multiple users are using and updating a shared workbook, will a problem occur if each of them save the workbook at different times?

    Thanks,

  2. #2
    Join Date
    Feb 2002
    Posts
    8
    Hi queequeg,

    You can use Excel Data Forms which can modify and add data in a spreadsheet:
    Highlight your current table range (Including field names/headers)
    Goto Data->Form...
    Click OK to confirm that the first row contains the headers.
    and there you have your form. New records will be added to the bottom of the table.
    Workbook sharing will work in the normal way: If two users attempt to save changes to the same cell, the first user will be able to save and the second user will be asked if they want to overwrite the first users data.

    A better way to do this would be to create an Access database and link the spreadsheet as a table. This would allow multiple users to enter data simultaneously avoiding conflicts. Also, Access' form wizards can build you an input form in a matter of seconds.

    Hope that helps,
    Dave.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •