Forum Discussion

Castellum812's avatar
Castellum812
Brass Contributor
Dec 14, 2021

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 ...
excel
Formulas and Functions
Castellum812's avatar
Castellum812
Brass Contributor
Dec 14, 2021
Thanks riny,

This is going to be a lot of study.
I'll deep dive tomorrow and see what new question arise 😉

  • Castellum812's avatar
    Castellum812
    Brass Contributor
    Feb 01, 2022
    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'?

Resources