When you drag a query or table from a registered database to a spreadsheet, you get a database range with name “Import1”. Is there a way in the UI to rename it? I know how to do it in the markup in the file. The question is, whether there exists a way to do it in the UI. Of cause, the database range shall still be linked to the query or table after renaming.
You can use MRI if that’s enough of a GUI.
I do not understand your answer. I mean the UI of Calc.
Calc has no UI for that. WIth MRI I call, menu:Toos>AddIns>Mri… double-click “DatabaseRanges”. then method “getByName”, pick “Import1” switch mode from “Get” to “Set” and double-click “setName” which promts me for the name.
1 Like
OK. MRI works, but needs to be done before any structured-references are used.