Why does Excel pop up a window that says Publishing when VBA script runs? What is it publishing? Where is it Publishing to? Is it necessary? If not can it be inhibited?

Thomas Ash 0 Reputation points
2023-05-06T00:57:45.3066667+00:00

I downloaded a Excel workbook with a data sheet and a form sheet and a VBA script to fill the form sheet with rows of data from the data sheet and then prints the form to a PDF. When I run the VBA script a pop up window comes up and says Publishing and has a progress bar. What is publishing in this context? Is it the export to PDF or is it compiling data from data sheet into form sheet? Or is it something else? In any event it runs forever and at the top of the screen it eventually says 'Excel is unresponsive' . I didn't see this behavior when I tested with 20 rows but when I expanded to 1000 rows it did and after a couple hours and only a dozen PDFs generated I killed in Task Manager.

Any help you can provide or insight to shed light on the issue is appreciated.



Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,592 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,621 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,632 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. S.Sengupta 16,476 Reputation points MVP
    2023-05-08T01:10:52.8733333+00:00

    Recompiling your macro often resolves this issue on Microsoft Excel. If you haven’t already, see the steps below to recompile your Excel VBA Macro.

    Access the Developers tab in Microsoft Excel.

    Click on Visual Basic.

    Go to the Tools tab and click on Options.

    In the new window, access the General tab.

    Enable the Compile on Demand option under the Compile section. Hit OK to save the changes.

    Restart Microsoft Excel.

    0 comments No comments