Deleting data from Shared workbook
 

Hi,

I am trying to delete data on a shared workbook through
automation.

m_pXlWorksheet-UsedRange-Delete(Excel::xlToLeft);

This throws an error even when the workbook is not opened
by anyone else. Does someone know if I should be using
someother method that Delete or using some flag with it?

Thanks.
Abhinav

Deleting data from Shared workbook
 

Abhinav wrote:
I am trying to delete data on a shared workbook through
automation.

m_pXlWorksheet-UsedRange-Delete(Excel::xlToLeft);

This throws an error even when the workbook is not opened
by anyone else.


From Excel help:

<<
Limitations of shared workbooks
Some features of Microsoft Excel are not available when you use a
shared workbook. If you need to use these features, do so before you
share the workbook, or remove the workbook from shared use.

In a shared workbook, you cannot do the following:

Cells
Merge cells. You can view cells that were merged before you shared the
workbook.

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

... etc.




Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup