Merged Workbooks Overwrite existing text

P

Puzzled user

Can anyone help please.

I have a shared excel document. This document is protected. 500 (or so)
rows have been unlocked starting at row 5.

I have sent the document via email to about 300 members of staff. They have
returned their spreadsheet to me via email.

Each spreadsheet has headings in the first 4 rows (which are locked) the
fifth row of every spreadsheet has been filled in.

When I have merged say 10 files into the original document, all 10 files
have inserted the data into row 5 and overwritten any existing data.

I did try this out before sending to so many people and it worked fine with
about 6 staff.

Does anyone have any ideas. I would be most grateful.

Thanks

A very puzzled user
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top