Microsoft KB Archive/111384

= Microsoft Knowledge Base =

Excel: EDITION.OPTIONS Function Doesn't Update Until Save
Last reviewed: September 12, 1996

Article ID: Q111384

The information in this article applies to:


 * Microsoft Excel for the Macintosh, version 4.0

SYMPTOMS
In Microsoft Excel for the Macintosh, if a published edition is created, then canceled, and a new edition is created in the same folder with the same name, you will receive the following error message:

Error Creating Publisher. No Publisher was created.

CAUSE
In Microsoft Excel for the Macintosh, using the EDITION.OPTIONS function to cancel a published edition will not delete the edition until the document is saved.

STATUS
This behavior is by design of Microsoft Excel.

WORKAROUND
To work around this problem, use the FILE.DELETE function in the macro after you use the EDITION.OPTIONS function. The EDITION.OPTIONS function removes the edition from the document, while the FILE.DELETE actually deletes the edition file.

The FILE.DELETE function allows the macro to run without requiring a save after executing the EDITION.OPTIONS function. The following is an example of how this macro might look.

=ACTIVATE("Worksheet1") =SELECT("r1c1:r10c1") =CREATE.PUBLISHER("Test") =EDITION.OPTIONS(1,"test",,1) =FILE.DELETE("test") =SELECT("r1c2:r10c2") =CREATE.PUBLISHER("test") =RETURN Microsoft provides macro examples for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This macro is provided 'as is' and Microsoft does not guarantee that the following code can be used in all situations. Microsoft does not support modifications of the code to suit customer requirements for a particular purpose.

MORE INFORMATION
For additional information, please see the following article(s) in the Microsoft Knowledge Base:

ARTICLE-ID: Q119000 TITLE    : EXCEL: "Error Creating Publisher" After Canceling Publisher