opening only a single worksheet not the whole workbook

[pjophil]

I have a very large workbook over a slow network. The workbook is composed of multiple worksheets that are tailored towards each user. I would like to have one main worksheet that opens as kind of like a "launch pad" where the specific user can click their name, and it goes out to this one large workbook and only opens their specific worksheet (without opening the ENTIRE workbook). Is this possible? Otherwise, each time a user wants to look at their specific worksheet, they have to wait for the ENTIRE workbook (10MB) to open first instead of their small 60K worksheet. How would this be coded? Any help would be appreciated. Thanks!!

 

[HalfAce]

Hi pjophil, welcome to the board.
There is no way to open a worksheet without first opening the workbook that contains it....
Sorry, I know that's not what you wanted to hear, but to the best of my knowledge, that's the way it is.

Dan

 

[erik.van.geit]

Unless ...
When you can read (and write?) to a closed workbook (http://www.erlandsendata.no/english/index.php?d=envbadacimportwbado)you could perhaps be able to copy an entire worksheet ???

second option
copy each sheet to separate workbooks
get them together again after operations
this can "easily" be done when there are no links between the sheets

or are this just dreams ?

kind regards,
Erik

 

[PA HS Teacher]

Am I correct in assuming that your end users only need to read, and do not need to write to your file?

A simple approach might be to save individual files for each of your users.

Perhaps a Save as event for your big file, that saves updated information to each of these small files?

Because, your end users do not make changes to the file, it does not matter that these small files will get overwritten each time you save the big file. (Perhaps that is the idea)

Just my two cents.