TheRevenant
New Member
- Joined
- Aug 13, 2016
- Messages
- 11
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?
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