Best practice for multi-tabbed Excel spreadsheet

I have a spareadsheet with 9 tabs. Users need to be able to view any of the tabs. I've created a page with a heading for each tab label. Under each heading I've inserted the Excel macro to display the appropriate worksheet. At the top of the page, I will (hopefully) put a TOC macro to give users easier access to the worksheet he/she wants to see. (That is, if I can get the TOC macros to display anything. That's a different topic.)

Does this approach make sense? Is there a better way to handle this?


2 answers

1 accepted

This widget could not be displayed.

I don't know of any other way to display individual pages in an Excel file.

So I think you've solved it, Sally, but depending on how much data there is on each of the spreadsheet pages are I think you're going to have to wait an age for all 9 sheets to load & render individually.

Can you use {viewxls} from another page or does it have to be attached to the current page? (too lazy to look it up). From the load/render aspect, it would probably be better to have the 9 sheets on separate pages, with next > previous links for navigation.

Sorry for the delayed response, Kathleen. I put them all on one page and waited for some feedback from users. We don't wait an entire age for it to render; just a couple years. I haven't heard any complaints yet but I'm going to do a sandbox page with the next buttons. That's a capability I haven't used yet and would liketo have in "Ye ole bag-o-tricks."

Thanks again for the suggestion!

:) Happy to help.

This widget could not be displayed.

I think that's were all of us think of having an alternative tool. I have been maintaining school database which has multiple tabs around 10-15. Every time I use that sheet its a biggest challenge to me. Of late I came across this tool with which I registers and have been developing a liking for that its CollateBox it allows me to create different views of data and though which I can immediately refer to which ever sheet I am required to.
Sally give it a try for once. It might do wonders for your use case..

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

569 views 7 6
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you