Newbie Power Query Help

[BogBeast]

Sorry, this is probably a very basic question but I don't usually use excel apart from the fact I am finding Power Query very useful analysing CSV that I generate

I create a very basic power query to import the CSV, it gets formatted, some basic calculations and the data gets graphed. Great..

That CSV gets updated and it grows. Next time I open the spreadsheet the power query runs and imports but the table(?) created doesn't seem to grow to support it. So the formulas don't use populated and the values don't get generated, apart from the last cell in the range. See attached for screen shot

I cant see how to fix it, any tips/help appreaciated...

 

[AliGW]

See if this helps at all: https://www.linkedin.com/pulse/dont-get-caught-power-query-trap-wyn-hopkins/

 

[BogBeast]

Thanks!

See if this helps at all: https://www.linkedin.com/pulse/dont-get-caught-power-query-trap-wyn-hopkins/

Thanks very much, it does - fixed!