About 1,798,406 results (3,288 milliseconds)
Getting the "calling workbook" for a function proves tricky
https://groups.google.com/g/exceldna/c/2kbBNTwonBw Oct 20, 2016 ... Ok, I think you're right that this is indeed a solution - the worksheet name is part of the sheet name. It relies also on the fact that Excel ...
What is the Google Sheets name for what Excel calls a workbook ...
https://support.google.com/docs/thread/40407678/what-is-the-google-sheets-name-for-what-excel-calls-a-workbook?hl=en Apr 16, 2020 ... I use the term Spreadsheet for the file, equivalent to workbook in Excel, and Sheet for each tab. These are the terms used in Google apps ...
Availability of a Workbook ID property similar to Worksheet ID?
https://groups.google.com/g/exceldna/c/Rnt1lBFP-wQ Mar 9, 2021 ... Once I have the calling sheet name, I can get the calling workbook using XlCall.Excel(XlCall.xlfGetDocument, 88, sheetName). workbookName2 won't ...
Create Defined Names from one workbook into another
https://groups.google.com/g/exceldna/c/uhrK_5UBQts May 28, 2024 ... Workbook thisWorkbook = excelApp.ActiveWorkbook;. Excel.Workbook ... foreach (Excel.Name definedName in fromWorkbook.Names) { if ...
Renamed a sheet in my workbook and now I have #REF! errors in ...
https://support.google.com/docs/thread/28435571/renamed-a-sheet-in-my-workbook-and-now-i-have-ref-errors-in-other-workbooks-that-were-linked-to-it?hl=en Feb 11, 2020 ... I reference cells in a sheet in workbook A in workbook B, but, unlike Excel, when I changed the name of a sheet in workbook A, it messed up my ...
What is the Google Sheets name for what Excel calls a workbook ...
https://support.google.com/docs/thread/40407678?hl=en&msgid=40475428 Apr 16, 2020 ... Google does not refer to the term workbook. Users of Google Sheet sometimes use the term workbook as a way to say the entire spreadsheet file.
Unwanted changes to named ranges (the name) when copying a ...
https://support.google.com/docs/thread/94827954/unwanted-changes-to-named-ranges-the-name-when-copying-a-sheet-to-another-workbook?hl=en Jan 23, 2021 ... I have multiple workbooks that have similar formatting. When I copy a sheet from one workbook to another, the named ranges change. Original ...
Display file name in a cell - Google Docs Editors Community
https://support.google.com/docs/thread/151853009/display-file-name-in-a-cell?hl=en Feb 22, 2022 ... Looking for a script to display the current file name in a cell, I have found solutions to display the sheet name but that is not what I need. I ...
Reference cell data from another Google spreadsheet (not a ...
https://support.google.com/docs/thread/8274394/reference-cell-data-from-another-google-spreadsheet-not-a-different-tabbed-sheet?hl=en Jun 18, 2019 ... What I mean is, say I have document A and B in Excel. If I want to ... =IMPORTRANGE("<share file link>", "Tab name!Cell ref"). But I am ...
Error "Unresolved sheet name" when copying tabs from one google ...
https://support.google.com/docs/thread/12478976/error-unresolved-sheet-name-when-copying-tabs-from-one-google-sheets-file-to-another?hl=en Aug 21, 2019 ... ... sheet name" when copying tabs from one google sheets file ... I simulated the same thing in Excel, works just fine there, because excel ...
Phantom External File Links, how can I break them?
https://groups.google.com/g/microsoft.public.mac.office.excel/c/hBVji035hqo it to be sure. So that's what worked for me. It seems that an Excel workbook can contain multiple occurrences of a named range. The Name View shows only one
activate sheet by name in Workbook object?
https://groups.google.com/g/spreadsheet-writeexcel/c/AfaJV3oAK1U May 13, 2014 ... ... file denoting a distribution list. if (!$needexcel) {$workbook = Excel::Writer::XLSX->new("$tmppath/$outxlfn"); $needexcel =1;} #if the ldif ...
How can I get Google Sheets to display the name of a named call ...
https://support.google.com/docs/thread/39249028/how-can-i-get-google-sheets-to-display-the-name-of-a-named-call-when-it-is-selected?hl=en Apr 10, 2020 ... This particular gsheet workbook was originally in Excel. I imported it into google sheets for the portability, but this single missing feature ...
Read Excel worksheet names with standard python?
https://groups.google.com/g/python-excel/c/V3yELPwY_I0 Dec 21, 2011 ... Only new .xlsx files are stored as zip files. Older .xls files are stored in a binary (BIFF) format. If you only need to ...
How do I delete multiple sheets at once in a workbook? - Google ...
https://support.google.com/docs/thread/3334810/how-do-i-delete-multiple-sheets-at-once-in-a-workbook?hl=en Mar 31, 2019 ... ... name), to copy the current sheet to another spreadsheet document. Maybe copying one or two would be faster than deleting many. Best,. Lance.
Dynamic file names in IMPORTRANGE? - Google Docs Editors ...
https://support.google.com/docs/thread/176276547/dynamic-file-names-in-importrange?hl=en Aug 23, 2022 ... If this were a desktop spreadsheet app, I could create a dynamic reference by entering the file name of the master copy into a cell and ...
Get the active sheet's name to be in a cell - Google Docs Editors ...
https://support.google.com/docs/thread/87383462/get-the-active-sheet-s-name-to-be-in-a-cell?hl=en Dec 7, 2020 ... I am building a workbook where I will be duplicating a sheet multiple times and renaming it each time. I want that new sheet name to appear ...
to get all sheet Ids on workbook
https://groups.google.com/g/exceldna/c/GA2lq-bKBG0 for a session even if i changed the sheet order or sheet name. Thanks for your support object result = XlCall.Excel(XlCall.xlfGetWorkbook, 16); string ...
Does ExcelReference contain the workbook encoded or not?
https://groups.google.com/g/exceldna/c/QDyQZQszGSk Jan 19, 2014 ... Most importantly, however, the ExcelReference constructor takes just a Worksheet Name, not a Workbook Name. This should not be correct as ...
Strategy for Copying Worksheets into a new book
https://groups.google.com/g/python-excel/c/7A4owntQO9Y <meta name=3D"Excel Workbook Frameset">. <meta name=3DProgId content=3DExcel ... >> this strategy. I'd suggest naming the file with .mhtml extension then using ...