It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Excel sheets Edited

Hello we are trying to have an excel sheet to display correctly on a confulence page. 

I have uploaded an excel xlsx file onto the webpage. The link is present and working, i then add the excel macro onto the page and link the previously linked file. 

Once published i get the error attached.ConfluenceError.PNG

If there is a way i can get this working please let me know.

Cheers

 

2 answers

0 votes
Mike_Rathwell Community Leader Aug 27, 2019

Hi @Sam Betlem 

It seems like you're somehow ending up with the wrong macro in there. Check your page and make sure you inserted the "Office Excel" macro and you are explicitly pointing at the Excel file in the configuration for the macro.

Hi @Mike_Rathwell 

 

I have attached two screenshots of how the edit view looks and the macro i have added.


ExcelMacro.PNGEditpagemode.PNG

Im sure im using the Office excel, i also thought it odd that it was referencing a PDF instead of xlsx file, but i can confirm that i am using what i would assume is the correct macro.
Can you confirm that im using the right setup?

Mike_Rathwell Community Leader Aug 28, 2019

Good morning @Sam Betlem ,

Can you click the "edit" on that macro and paste the screenshot of the configuration for it?

Hey @Mike_Rathwell 

I discovered the issue. To get the excel sheet to work correctly i had to split the sheets of the excel into separate documents and then link them in. This gave printed the results, to be honest after looking at the layout i found it easier to print the excel sheets as PDF's then used the PDF macro which worked fine. 


Hi Sam, 

If this helps any, you can give the app - Excellentable - Spreadsheets for Confluence a try!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

How is your team having fun and bonding, remotely, utilizing Confluence?

Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...

294 views 9 7
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you