To publish reports from Anaplan XL you will need to have Anaplan XL Web installed on a suitable server. The publication process is straightforward and any report that can be opened in your Anaplan XL enabled version of Excel can be published.

Publication process 

To begin the publication process, first, open the Anaplan XL report and select the Publish to Web ribbon item or the Anaplan XL > Publish to Web menu option in Excel 2003 and below. The Publish dialog opens.

You can connect to an Anaplan XL Web server and select where the current report should be published:

  1. Enter the name of the Anaplan XL Web server you want to connect to in the Server Address field. This'll depend on how you have installed the Anaplan XL Web software on your server.
  2. Select Connect, and if the connection is successful, the folders available on the server will be displayed in the box below.
  3. Type in the Name that you want to give the report. The name appears in the Navigation tree view and on the report's tab.
  4. Select where to publish. Navigate through the folders on the server to find the location you want. The report will be published to the folder that is currently highlighted.

Existing reports are also shown in the tree. If an existing report is highlighted, then Anaplan XL will attempt to replace it with the published report.

Your Administrator may have set up the Anaplan XL Web Server differently. You might be able to see a folder, but you may not have the security permissions to write or publish to it. If this is the case, a message will say that you can't publish it. You must choose a folder to which you can write. Contact your System Administrator to discuss permissions further.

Choose options

Publish & View opens the published report in your web browser when the publication process is finished.

Select the Preview button to view the report in a browser without permanently publishing it to the server. A new browser window is opened when this option is selected.

Select the Publish button to publish the report to the server. On successful completion, a message is displayed confirming that the report will now be available in Anaplan XL Web repository.

If you see the message:

"The maximum number of rows that can be published is 1000. Sheet1 has xxx rows".

See Publishing more than 1000 rows.