Deleting data from Shared workbook

  • Thread starter Thread starter Abhinav
  • Start date Start date
A

Abhinav

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
 
Abhinav said:
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.
Click to expand...

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
 
Back
Top