Maxim on 06 Jul 2020 19:31:04
Please add a feature to generate a linked table from a function.
PowerQuery has a good feature where you can generate Functions from tables that have paramenters.
When you do that the table becomes linked to the function and any changes to the table are applied to the Function. It is very useful for testing \ designing.
Unfortunately, once you move the Function to another workbook the link is broken. So if you want to make any adjustments you either have to find your initial workbook or do it in code with no way to see intermediary results.
It would be very useful to be able to generate a linked table\linked parameters directly from a function.