Question

what is workbook and sheet name.
who know the answer only then can answer​

Answer 1

Answer:

At least one worksheet should be added to a new workbook. The Worksheet object is used to write data and configure a worksheet in the workbook. The worksheet name must be a valid Excel worksheet name: It must be less than 32 characters.

Answer 2

workbook and sheet name via formula

I have a standard header I put on almost every excel workbook I create I have been using for years. It includes several standard items, including Workbook name and Worksheet name, which are extracted via CELL("Filename",A1) formula.

For Excel workbooks that are being viewed in Excel Online, however, whether through onedrive, sharepoint, or whatever, this formula yields a #VALUE! error. When I open in desktop, it renders fine, just not when looking at browser window.

Is there an alternative that I can use to display current workbook and worksheet names via a formula in a cell that is compatible with Excel Online?