Microsoft KB Archive/119000

Microsoft Knowledge Base

"Error Creating Publisher" After Canceling Publisher

Last reviewed: September 13, 1996
Article ID: Q119000

The information in this article applies to:

• Microsoft Excel for the Macintosh, versions 4.0, 5.0

SYMPTOMS

In Microsoft Excel, when you create a publisher, and you then cancel the publisher, if you publish to the same edition again, with the same cell range, you receive the following error message:

   Error creating publisher. No publisher was created.

CAUSE

This behavior occurs if you do not save the publisher file after canceling the publisher. This behavior occurs because the published edition is not deleted until you save the published document. You cannot publish to an existing edition without changing the published cell range.

WORKAROUNDS

To avoid receiving this error message when you create a publisher, do either of the following:

• Save the file after you cancel the publisher -or-
• Give the published edition a different name than the edition of the canceled publisher.

MORE INFORMATION

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

   ARTICLE-ID: Q111384
   TITLE     : Excel: EDITION.OPTIONS() Function Doesn't Update Until Save

REFERENCES

For an Overview Of Creating Publishers And Subscribers In Microsoft Excel For The Macintosh, choose the Search button in Help and type:

    publishers

KBCategory: kbole KBSubcategory: Additional reference words: 4.00 5.00 7.00 7.10 7.x err msg 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 13, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.