Shared Workbook Query

O

officeworker

Hi,

I have set up a shared workbook for 20+ users. I am aware that share
workbooks in Excel (I have version 2002) have limited functionality an
that you cannot for example merge cells.

However, if there are merged cells in another worksheet and someon
wants to copy across text (which includes merged cells) into the share
workbook it removes the merged formatting.

At present I have to take the share off the workbook and then cop
across the data (which includes merged cells) then reshare the workboo
so that the formatting is maintained.

Is there any other way around this problem so that people can cop
across formatted text from another worksheet when it is in share
mode?

Any tips or advice would be appreciated.

Thanks
 

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

Similar Threads

Sharing workbooks limitations - Merged Cells 12
Page numbering with Merged Document and IF statements 1
Anchor issue with inserting a shape for letterhead 1
Excel does not accept text format! 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Shared Workbooks & Code 1
Shared workbook opens with all rows hidden 0
Shared Workbook Saving issue 2

Top