Hi Leah,

It's case sensitive, the formula is Excel.CurrentWorkbook with a capital W.

Mynda

I've written so now and it still brings me the same error

= Excel.CurrentWorkBook()

All functions should be case sensitive?

Only the E, C and W are upper case, the B is lowercase. Exactly like this:

Excel.CurrentWorkbook

Hello,

I am now in Exercise 3.02

Inserts the Excel.Workbook function

But I get an error message -

Expression.SyntaxError: RightParen Token Required.

Screenshot from France

Thanks for help,

Leah

Looks like you're missing a second closing parenthesis.

Okay, worked for me.
After doing the whole process -
I added a given in one of the tables - I clicked Refresh
And he doesn't show the new figure.
Because it's a non-dynamic table?
What to do with Have a file as an exercise with lots of non-dynamic tables
And want the new data to be updated in the central table?

Hi Lea,

I'm not sure I understand your question, sorry. Power Query will pick up new data from the practice file pq_3.02.xlsx if you make changes. I tested it and it works for me.

Note; the source files must be closed to refresh.

Mynda

Hi,

From your answer I realize I need 2 files -

1. The original file - where I can add data and sheets

2. Another file on which Query is run and it collects the data from the original file.

Is this indeed the case?

Because I did so and got an error message -

As pictured here is a screenshot.

Hi Lea,

This lesson looks at getting data from another file, but you can also get data from the current file as shown in lesson 2.03.

The error shown above is another case sensitive issue. The function is File.Contents with a capital C. Unlike Excel, you must respect the capitalisation of the function names exactly as shown. It won't auto correct if you type them in wrong, like Excel functions will.

Mynda