Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,804 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
My Set-up: MacOs, Excel Desktop
Problem: when loading a template file via insertWorksheetsFromBase64 to insert new workbook the formula (Formula > Name Manager) losts it's reference from the source workbook. Instead, it returns =#REF!$[Location] in the formula.
For example: in the template file, i named the B2 cell to qxInput (picture below). After copying the source workbook to the current workbook, the sheet reference was not found. If I then load another workbook, the namedItem is still visible.
Question:
It works fine on Excel Browser
Fotos: