Hi,
May i confirm if all data must first convert into "table/ range" before upload into Power Query platform? This is because, i have input some excel formulas in the middle of columns ranges of my workings. I am worrying the existing excel formulas might get lost after converting them into "table" and fail to get read by Power Query?
instead of converting into "table", if i choose to convert data into name range (eg: i named it as "table1" from cell A1 to A4), would it create a problem when i top up data to next row "cell A5" in future and then click refresh button? i believe the name range will not auto capture my additional rows in power query?
Thanks.
Converting the data to a Table won't break the formulas. I wouldn't worry about it, but if you insist on not converting them then you would need to create a dynamic named range that adjusts as your data grows and then use the Excel.CurrentWorkbook function. That's why it's easier to just convert it to a Table.
