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

unknown

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.