BackOffice Products
1827415 Members
4863 Online
109965 Solutions
New Discussion

Opening a worksheet in Excel on the web

 
Daniel M. Gonzales
Frequent Advisor

Opening a worksheet in Excel on the web

When viewing an Excel file (xls) with multiple worksheets via the web, is there a way to a specific worksheet?
3 REPLIES 3
Jon Finley
Honored Contributor

Re: Opening a worksheet in Excel on the web

You SHOULD be able to simply click on the Worksheet tab at the bottom of the Workbook.

Sheet1, Sheet2, Sheet3, etc.

Jon
"Do or do not. There is no try!" - Yoda
Daniel M. Gonzales
Frequent Advisor

Re: Opening a worksheet in Excel on the web

John, that is correct. You can click on the desired worksheet. However, I have a large Excel file that has MANY worksheets. Would like to open the file (via the web) and got directly to the desired worksheet.
Jon Finley
Honored Contributor

Re: Opening a worksheet in Excel on the web

The ONLY way I was able to open a specific worksheet was to create (insert) a name into each worksheet. Then I was able to reference the named cell (like a link) in the url

http://www.mywebsite.com/share/myworkboot.xls#Sheet1

Where A1 had been named Sheet1.

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B234780

Jon
"Do or do not. There is no try!" - Yoda