Best practice for multi-tabbed Excel spreadsheet

[SallyD]

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?

Sally

[Deleted user · Accepted solution]

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.

[SallyD]

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!

[Deleted user]

:) Happy to help.