Power Query importing Files from a Folder Error

DMfba

New Member
Joined
Mar 21, 2019
Messages
8
Hi All,

I hope this is a simple fix that. I am importing multiple excel .xlsx files from a folder as i have done in many times in the past but came across an error i can not resolve. After selecting my folder that I want power query to import i go into the edit option to extract the excel data in the file. Typical i would remove all but the content column then add a custom column. The formula i am using is =Excel.Workbook([Content]). After creating the column it shows there is an errors in each row.

Expression.Error: We cannot apply field access to the type Function
Details:
Value=Function
Key=Content

Does anyone know how to fix this error? Or a better way to extract the excel data?
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,099,893
Messages
5,471,333
Members
406,757
Latest member
dizzane

This Week's Hot Topics

Top