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 ...
Hi Riny,
Only Just started. Sorry for that 😞
I've achieved good progres but bump into some small issues.
After creating a query PQ generates 'Named Ranges' like 'Table1 or Table _1'
If I decide to delete the query, done it a lot during experimenting the 'Named Ranges' do net get deleted.
Under the 'Name Manger' I can change the names for the ranges but I can not delete them.
Is there a way to get rid of these 'Ranges'?
Only Just started. Sorry for that 😞
I've achieved good progres but bump into some small issues.
After creating a query PQ generates 'Named Ranges' like 'Table1 or Table _1'
If I decide to delete the query, done it a lot during experimenting the 'Named Ranges' do net get deleted.
Under the 'Name Manger' I can change the names for the ranges but I can not delete them.
Is there a way to get rid of these 'Ranges'?
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.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.
