Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving data to a shared workbook | Excel Discussion (Misc queries) | |||
Shared workbook loses data | Excel Discussion (Misc queries) | |||
Data Entry in shared workbook | Excel Discussion (Misc queries) | |||
Why do I lose data in a shared workbook? | Excel Discussion (Misc queries) | |||
How can I prevent someone from deleting a shared workbook? | Excel Worksheet Functions |