I'm using an Excel sheet as a database for WORD mail merge. I would like to
use the standard "Form" found under Data the button to update the
spreadsheet. The problem is that when I set the worksheet to be "shared" I
lose access to the "New", "Delete", and "Restore" buttons on the form.

If I don't check that the file should be shared, then someone wanting to
update the sheet is locked out if a Mail Merge is being done in WORD.

I've looked at the "JWalk Enhanced Data Form", but the users seem to like
the default Form version if this problem could be fixed.

Just my 2 cents.

I doubt whether MS considers this a problem to be fixed. I'd bet that they
consider it a feature that's unavailable with shared workbooks. I wouldn't hold
my breath for an update to an existing version.

In excel's help for "Features that are unavailable in shared workbooks", they
mention that "Insert or delete blocks of cells" is not available.

If you use data|form to insert/delete a record, then you're not
inserting/deleting the whole row.

So it's even documented as a limitation.



fishcents wrote:

I'm using an Excel sheet as a database for WORD mail merge. I would like to
use the standard "Form" found under Data the button to update the
spreadsheet. The problem is that when I set the worksheet to be "shared" I
lose access to the "New", "Delete", and "Restore" buttons on the form.

If I don't check that the file should be shared, then someone wanting to
update the sheet is locked out if a Mail Merge is being done in WORD.

I've looked at the "JWalk Enhanced Data Form", but the users seem to like
the default Form version if this problem could be fixed.

--

Dave Peterson