Team A documents stuff almost exclusively through Excel. Team B documents stuff almost exclusively through Confluence.
B relies heavily on A's Excel data, so periodically someone manually copies individual Excel cells onto Confluence. Beyond being inefficient, the problem is that the Excel file gets updated fairly regularly, the Confluence pages doesn't, so Team B ends up referencing outdated information.
I want Team A to be able to edit their Excel files like they normally do, and I want Team B to receive that new data on Confluence in real time.
I tried out the "Office Excel" macro, but it looks like it'd still require someone to re-attach the Excel file. I see the Companion app for Cloud is retiring in 2022, so that doesn't look like a solution either.
Is there a macro that I can tell to "look for X filename.xlsx in A:\blah\blah file path"? Or something else?
-edited a typo.
Have you tried beating Team A? ;-)
Has Team A tried editing in place?
If they followed this method, then at least the attached file would always be current.
A more robust solution would be this paid plugin:
We have used this before to try to bridge the gap between the ludites mired in the 00s and us cool people. ;-)
And you might need to get Team A to meet Team B halfway and have the infor within their spreadhseets replicated on some other sheet to make it easier for Team B to consume.
Hi @Catherine Snell ,
We can also suggest trying our app - Table Filter and Charts for Confluence.
The app provides the Table from CSV macro that allows you to connect CSV files via attachments and URLs (Google Spreadsheets as well) to Confluence.
The recreated table can be further filtered, aggregated, recalculated and visualized right in Confluence with the help of other macros provided by the add-on.
Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...
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