Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
59
Views
Topic starter
This sheet collates historical stocks data using power query. When refresh the sparklines disappear. The new data overtype the old ones. And when I (copy /paste link) the data to a new file or sheet, all give #REF error in all cells. I Is there another way to avoid this #ref error? Other than using (find/replace all) with the actual links. Thanks
[Image Can Not Be Found]
Posted : 19/10/2020 4:40 pm
Hi Walid,
What is it you are actually trying to do? Why are you copying data to a new sheet or workbook?
Can you please supply your workbook(s).
Regards
Phil
Posted : 19/10/2020 10:55 pm