Click here to Skip to main content
15,943,008 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi guys, I hope you can give me some insights of what I am trying to do.

Basically, I have a worksheet (WBook A) that references its data - using Power Query - from another workbook (WBook B)that I am downloading from the internet - a CSV File. What I am trying to do is to get the desired data from WBook B to show as a report in WBook A. The problem though is that, whenever I try to update the information in WBook B, I'm always getting errors stating that a connection and/or the Data Model is broken.

Am I doing something that I am not supposed to be doing here? Or do I need to change my approach on updating the data?

Any help or insights would be very much appreciated.


What I have tried:

What I am doing, and I don't want to keep on doing is that whenever I have newly downloaded CSV file, I copy and replace the old one and after that I need to recreate the table query in WBook A in order for it to be updated. I have like 3 thousand rows from WBook B that I am referencing from based on a row, named SKU using VLOOKUP and IF statements and copying the information from the new CSV file to the old one will be a tedious one since I have a lot of cells with information.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900