I'm trying to create a link to a xls workbook to a particular worksheet, but I can't seem to get to open the the correct worksheet.

\ibreports\emsfiles\fullCompany2.xls#'Sheet2'

The above is how I currently have set, it will open the workbook but not "Sheet2" - can anyone tell me what I need to do to fix this.

Hi Cathy,

I did some testing and research on this one. Just wondering, are you trying to import data from Excel to WebFOCUS? Or are you trying to open a particular worksheet from browser? I tried your way, \ibreports\emsfiles\fullCompany2.xls#'Sheet2'

but received an error message. So please provide a little more details of your question so we can have a better understanding. Thank you in advance for sharing.

Cheers,

Kerry