using forms in a shared workbook

[Dan23]

I'm trying to help three people share a master workbook. I'v
implemented a process involving shared a shared workbook. The troubl
is, they like entering their data in FORMS which seems to be disable
once the workbook is shared. Who knew.

Anyway, anybody know of a way for me to help these people keep thei
precious forms while also maintaining an effective shared file?

FWIW, this is what MS has to say about disabled fearues with sharing o
-- I don't see forms spelled out, but maybe it's something to do wit
data tables:

"The following features can't be changed after a workbook is shared
merged cells, conditional formats, data validation, charts, pictures
objects including drawing objects, hyperlinks, scenarios, outlines
subtotals, data tables, PivotTable reports, workbook and workshee
protection, and macros."

Thanks,

Da

 

[Dave Peterson]

I could use Data|Form to change existing data in my form (I'm using xl2003).

But I couldn't delete or add a new record.

But under excel's help for: Features that are unavailable in shared workbooks

I see this:

Unavailable feature Alternatives
Insert or delete blocks of cells You can insert entire rows and columns.

So it sure looks documented to me.

 

[Dan23]

Thanks, Dave. I guess I was reading an abbrev. set of limitations. An
I did see the ability to read via Forms, but was really interested i
entering new records.
The ease of data entry seems to be of most importance to these folks
so I'll probably work out a process for cutting and pasting update
periodically into a master document without turning on sharing.

-Da

 

[Dave Peterson]

Maybe you can include some blank rows at the top of your data (or intermingled
with the data)--and name that extended range: DataBase

(or sheet1!Database to give it a worksheet level name.)