Displaying the 2nd or 3rd worksheet on web pages 
Author Message
 Displaying the 2nd or 3rd worksheet on web pages

Hi

In Office 2K I can save an Excel workbook as html so it can be accessed as a
web page and all the worksheets are accessible.

Is there a way to set the link/URL directly to the second worksheet of a
workbook? I have tried a number of things none of which work.

Thanks
Richard.



Tue, 21 Dec 2004 23:39:17 GMT  
 Displaying the 2nd or 3rd worksheet on web pages
Richard,

IIRC, only the first sheet of multi-sheet workbooks get converted, and all
others are simply deleted.  The workaround is to move your other sheets to
ranges below or to the right of the used range on your first sheet.

HTH,
Bernie


Quote:
> Hi

> In Office 2K I can save an Excel workbook as html so it can be accessed as
a
> web page and all the worksheets are accessible.

> Is there a way to set the link/URL directly to the second worksheet of a
> workbook? I have tried a number of things none of which work.

> Thanks
> Richard.



Wed, 22 Dec 2004 01:28:19 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Displaying: date: 1st, 2nd, 3rd, 11th, 21st

2. Displaying Day as 1st, 2nd, 3rd, etc.

3. Microsof publisher How to print 2nd 3rd and 4th quarter of page

4. Update 2nd page Footer w/o 2nd page

5. need to re-display list box 2nd page of sub-report

6. Start page numbering on 3rd page with Page 1

7. 2nd REQUEST - Page Condensed on web site

8. help on viewing second page of web home page with preview Web Page

9. Resolve to 2nd or 3rd email

10. Get 1st, 2nd, and 3rd Letter From a String


 
Powered by phpBB® Forum Software © phpBB Group