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 macros | "Error rendering macro 'viewxls'"

I have a spreadsheet I would like to have live in Confluence for additional viewers. My goal is to have it as an image, or a link, but it cannot be editable. 

What are the requirements of the Excel document in order for Confluence to refresh that data, so it reflects changes? I have followed several how-to articles for adding an Excel macro, but have not been successful in seeing the Confluence document reflect the updates I make within Excel.  When I click the "edit" option on the uploaded document, I get this error message for the macro: 

Error rendering macro 'viewxls'

The viewfile macro is unable to locate the page " Embedded Excel Files" in space "TEST"

 

 

1 answer

Hi Casey,

Since the permissions are based on page and space, any-one with edit access to the page will also be able to edit the macro.

There are two solutions i can think of:

1. Create a the image/table in a space that does not give the rest of the users edit permission and then use include macro in the destination to dis-allow edits

2. Use a spreadsheet tool like Excellentable, and protect the sheet

The Error rendering macro 'viewxls' IIRC was an issue with some of the larger spreadsheets. What is the size of your spreadhsheet? is it more than 2-3 MB?

Suggest an answer

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

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

8,532 views 6 6
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