Apologies in advance if I don't articulate this clearly. I'm not sure I understand myself exactly how to say describe it.
I have 3 tables, one in each column (A-C below)
I am using Power Query to do a cross join (or cartesian join - not sure the right name) and the output of that cross-join is displayed two columns over. (F-H)
I've set this up exactly as I want it and it works great. If I change the data in the tables in columns B, C, or D, and then hit refresh, the cross join will update with the new data properly populated. WONDERFUL!
BUT, if I make a copy of this worksheet and rename it, this copied worksheet does not behave the same way. If I change the data in the 3 tables on the second, copied sheet, and hit refresh, it does NOT update and populate properly.
Two questions:
- why does the first sheet update the cross-join properly when I change the values in the 3 tables, but this does not happen on the copied sheet?
- I need to make 50 more of these sheets - how can I mass copy to create them all but have each sheet be its own unique set of tables and cross joins?
Thanks!
Excel 2016 (Windows) 64 bit
I have 3 tables, one in each column (A-C below)
I am using Power Query to do a cross join (or cartesian join - not sure the right name) and the output of that cross-join is displayed two columns over. (F-H)
I've set this up exactly as I want it and it works great. If I change the data in the tables in columns B, C, or D, and then hit refresh, the cross join will update with the new data properly populated. WONDERFUL!
BUT, if I make a copy of this worksheet and rename it, this copied worksheet does not behave the same way. If I change the data in the 3 tables on the second, copied sheet, and hit refresh, it does NOT update and populate properly.
Two questions:
- why does the first sheet update the cross-join properly when I change the values in the 3 tables, but this does not happen on the copied sheet?
- I need to make 50 more of these sheets - how can I mass copy to create them all but have each sheet be its own unique set of tables and cross joins?
Thanks!
Excel 2016 (Windows) 64 bit
Food1 | Food2 | Food3 | Food1 | Food2 | Food3 | |
Fish | Dairy | Fruit | Fish | Dairy | Fruit | |
Cod | Cheese | Apple | Fish | Dairy | Apple | |
Milk | Fish | Cheese | Fruit | |||
Fish | Cheese | Apple | ||||
Fish | Milk | Fruit | ||||
Fish | Milk | Apple | ||||
Cod | Dairy | Fruit | ||||
Cod | Dairy | Apple | ||||
Cod | Cheese | Fruit | ||||
Cod | Cheese | Apple | ||||
Cod | Milk | Fruit | ||||
Cod | Milk | Apple |
Sheet: Sheet1 |
Last edited: