View Excel Macro Will Not Load Attached Files

Still need help?

The Atlassian Community is here for you.

Ask the community

This article requires fixes

This article has been Flagged for fixing. Use caution when using it and fix it if you have Publisher rights.

Symptoms

When Attempting to Load an attached .xls or .xlsx file using the View Excel Macro in a confluence page after attaching an Excel file to a page and try to insert the view Excel macro, the macro menu doesn't show the attached Excel file in the relevant drop-down field. As a result, I'm not able to insert the attached Excel file into my page.  There is nothing in the error logs indicating that any is wrong.  And this only occurs in some pages.

The Macro settings appear as follows:


If  page title contains colon ":" character, attachments might not be displayed due to the known bug CONFSERVER-24540


Diagnosis

  • You have an Excel document attached.
  • The Document can be downloaded and contains no errors
  • The File will not display in the Field Name Field
  • The same file will however load into another page with the same settings using the Excel Page macro

Workaround

Simply Dragging and Dropping the excel file from your local file browser into the page being edited, will bypass this behavior and allow the excel macro to load the file.

Resolution

  • Option 1
    • Download the file from the page
    • Enter the edit mode for the desired page
    • Open a file Browser window and navigate to the downloaded file

    • Drag the .xls or .xlsx file into the page being edited

    • this will bypass the upload feature and attaches directly to the space, allowing the Excel macro to load appropriately. 
      • with this method it will continually fail to load when trying the upload from attachments method for future attachments.
  • Option 2

    • Copy all information from the page 

    • Delete the page and create a new one

    • Paste the information into the new page
      • This method will only copy text and require rebuilding any macro configurations, and formatting




Last modified on Oct 15, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.