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

REFERENCES

"Function Reference," version 4.0, page 126

KBCategory: kbmacro KBSubcategory: Additional reference words: 4.00 THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: September 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.