Modify csv data source that is connected to a XLSM file via power query

[TheRevenant]

Hi there.

I have developed a SQL script that exports a csv file.

I have imported this csv file in a .xlsm file and have made pivot tables and other worksheets that are dependent on this table.

It turns out I forgot to trim the spaces in the custname and need them removed. I have modified my SQL query and produced the corrected csv output.

However when I refresh the XLSM sheet, those changes do not appear in the XLSM.

What do I need to do to make this happen?

I have spoke to so many people about this and they cannot figure it out.

I cannot attach files here?

Modify csv data source that is connected to a XLSM file via power query

Hi there. I have developed a SQL script that exports a csv file. I have imported this csv file in a .xlsm file and have made pivot tables and other worksheets that are dependent on this table. It turns out I forgot to trim the spaces in the custname and need them removed. I have...

www.excelforum.com

 

[sandy666]

It turns out I forgot to trim the spaces in the custname and need them removed. I have modified my SQL query and produced the corrected csv output.

However when I refresh the XLSM sheet, those changes do not appear in the XLSM.

try PQ again or fix headers in the code (no spaces)
eg. " name" is not the same as "name"