Customer experience | Sales, Customer Insights,...

Advanced Find - Dynamic Worksheet Export

(0) Share

Report

Posted on by KTL

Hi Everyone,

Hope you are all keeping well!

I have a quick question, if there a way to find out which Advanced Find a Dynamic Worksheet is pulling data from? I have a client who can't seem to locate which Advanced their Dynamic worksheet is using as the source of data.

Many thanks in advance!

All responses (3)

Answers (0)

Joao Pratas on at

Like (0)

Report

RE: Advanced Find - Dynamic Worksheet Export

Thank you for your response.

Can you let me know if the info shared above resolves your question? If yes, please mark it as an answer for your question. :)

Thank you!
KTL 5 on at

Like (0)

Report

RE: Advanced Find - Dynamic Worksheet Export

Excellent! thank you!
Suggested answer

Joao Pratas on at

Like (0)

Report
RE: Advanced Find - Dynamic Worksheet Export

Hi KT,

Please try the following steps:

In your Excel file, go to Data tab -> Get and Transform Data -> From Table/Range

In Power Query Editor, click Advanced Editor.

This page should show you what is the view that is being used to pull the data into your table.

Hope this helps!

Kind Regards,

João Pratas