<div>
&gt;&gt;I am working on a shared excel workbook The consensus opinion of Experts here is that using 'share workbook' should be assiduously avoided. &nbsp;This is a poorly implemented feature in Excel that leaves workbooks highly vulnerable to corruption. &nbsp;If true multi-user capability truly is needed, then the best practice is to use a database platform such as Access, SQL Server, MySQL, etc.Just about the only use for shared workbooks endorsed by the Experts here is to enable 'track changes',and even then, the workbook should still not be used by multiple users at the same time.It is only a small exagerration to say that there are only two kinds of shared workbooks: those that havebecome corrupted, and those that soon will be :)
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I am working on a shared excel workbook and want to make use of the ActiveWorkbook.RejectAllCh<wbr />anges method.<br />
However any time I try and use it I get run-time error 1004, method failed error.<br />
<br />
I can't see to find any helpful reference guides on the method so posted this question in case someone has been successful with it.<br />
<br />
Thanks,<br />
Gerry.
</div>
</div>


Hi Experts,
I am working on a shared excel workbook and want to make use of the ActiveWorkbook.RejectAllChanges method.
However any time I try and use it I get run-time error 1004, method failed error.

I can't see to find any helpful reference guides on the method so posted this question in case someone has been successful with it.

Thanks,
Gerry.

ActiveWorkbook.RejectAllChanges method explanation

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.