I want to embed an Excel file into a page, so that it may be edited there. It is not important to actually see the content of the Excel sheet on the page.
When I select Insert Select content/Confluence content/Excel, then Insert Office Excel macro, then under File Name, it says: "No appropriate attachments". Where do I populate the dropdown so that there is 'appropriate attachments' to select from?
BW Peter Hansen
Hello Peter, good afternoon!
I think you have two situations:
For the first one:
You can edit the document in Confluence if you use the Macro Office Excel.
And it will show to you the option to Edit Document, it open a Excel File and you can edit the file.
Observation: I think you need use the Internet Explorer to work, but I'm not sure about it.
To the second
is that what happened to you?
If it is that.. you have a 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.
And resolution is:
Open a file Browser window and navigate to the downloaded file
Drag the .xls or .xlsx file into the page being edited
Copy all information from the page
Delete the page and create a new one
Lemme know if I helped you.
This is indeed the answer to the original question:
"When I select Insert Select content/Confluence content/Excel, then Insert Office Excel macro, then under File Name, it says: "No appropriate attachments". Where do I populate the dropdown so that there is 'appropriate attachments' to select from?"
The macro is looking for attachments to the page. You have to add an attachment to the page.
with the page in normal "View page" mode, i.e. not Edit mode where you insert the macro, just use your PC file browser to drag and drop a file onto the page.
Click the Ellipsis three dot icon, select <<Attachments>> and browse or drag and drop your file there.
Your macro should then kick in to life.
More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs