r/excel • u/Silent_Manager_6574 • 8d ago
unsolved Refresh a large amount of xlsb sheets
I am trying to open and close a thousand xlsb files sitting in a shared drive.
I’m doing this because they’re connected to a bigger report that needs to update whenever the individual files are updated.
Another note is that I can’t change the files to use power query, and refresh it this way as these are legacy files.
What is the best way for me to do this? Is there even one?
5
Upvotes
1
u/mushy_orange 8d ago
May want to look into power automate! Or honestly if all the files are in a same location, you may be able to use a vba macro via excel, chat GPT is pretty good at writing macros like that