Forum Discussion
Conversion of 'Complex' Google sheet to Excel
Hi There We are currently switching from Gsuite to Microsoft. This involves converting current google sheets to Excel. I have a rather complex sheet with quite a bit of Array functions that ...
Castellum812 Ctrl-click the named ranges you want to get rid of and press the Delete button.
I assume in the 'Name Manager' ?
That does not work either.
If I select multiple ranges the 'Delete' button does change but when I press it to delete nothing happens.
That does not work either.
If I select multiple ranges the 'Delete' button does change but when I press it to delete nothing happens.
- Thanks Riny
By now I had discovered the 'Load to' possibility.
But apparently I had created the table in one of the earliy steps I took.
I now converted it to a standar range and deleted it.
Thanks Castellum812 Named ranges can be deleted via the name manger, but not tables. You can change the table names, though. When you use PQ, but don't want a table for each query you created, set the Load options to "Connection only" and/or "Add to data model". No tables will be created but you can still work with the transformed data in other queries or create pivot tables from them.