1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Power Query Refresh Time

I created an Excel file with a Power Query product database. It takes item-level data (sizes, colors, logos, etc.) from an Item Master, expands it into all SKU combinations, and builds out a final product database with pricing and item info. It also pulls in a predetermined product codes from a separate tab with 300,000 rows.

When I refresh the file (both at home and at work), it takes about 20 seconds with 50 rows. I had a couple coworkers try the exact same file, and it takes about 2 minutes for them to refresh. It is the same file, same data, same network, and similar computers.

I can’t figure out why it’s consistently faster for me than everyone else. Any ideas of what could be causing this?

submitted by /u/Presto1985
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com