Hi all,

I have a few spreadsheets which are all based on one huge SOURCE table. This table is populated with data from an SQL database which is loaded by a VBA script.

From this source table - I've built two additional sheets which in turn both are pretty big.

The purpose of this is that I want to create new tables which contains specific information I'm interested in from the source table AND perform a few new calculations using standard excel formulas.

Procedure:

1) Create new sheet with new table

2) Create links from source table to new table by simply using the formula "=" on the top cell in new table, find top cell in desired column in source table and click enter. Repeat until table is complete.

Simply like this - except that I have tables.

Now, this is working FINE, but on my largest workbook consisting of two linked sheets with additional formulas - I have some issues with stability. At times - it can load pretty fast. Other times - it tends to freeze a bit.

Question is - Is PowerQuery a better solution to accomplish this? Is it likely to be faster/more stable?

It will likely take me an entire day to re-create all this. Maybe more. So I figured I could ask here first.

One advantage with a direct link is that my entire workbook is updated at once. Of course, that can be accomplished in PQ as well using VBA.

Thanks in advance for any pointers on the subject!

Best regards,

Elijah