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.
Does not work for me either, it uploads a link and the file cannot be viewed as a table as either .xlsx or .xls.
I managed to create the page, upload the file, use the macro, all is good and hit insert. Nothing. Just a link.
We would love to use the page with the excel sheet as a place where people can load data into (numerous as once if possible), we then run a report every month and annually from it.
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.
I am glad you mentioned this Stefan ....
I haven't seen any documentation about limitation of characters in the page title ... is there any information in the Confluence Documentation that talks about this?
Or in the Community pages?
A link would be helpful ...
I am now trolling through our association's 500 Spaces to see if there are any colon instances that might cause problems in various macros ... :(
Might be helpful if you describe precisely what you have done ...
I just tested on my cloud instance: https://ideology.atlassian.net/wiki/x/CICtLQ
Build info Confluence 1000.0.0-438ed42757d
Created a new page and Published as completely blank page.
With page in normal View mode, I Dragged and dropped an Excel file from File Explorer onto the page
Edited the page to insert the attached file
Clicking on the image gives me the viewer window ... I can download it from there
Clicking on the <<Edit file>>option however doesn't seem to work
I then edited the page to insert the Excel macro below the horizontal line .. it automatically identified the attachment
It displays the Excel content but it doesn't seem to allow to edit the file onscreen
- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...
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