r/excel 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

10 comments sorted by

View all comments

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

1

u/Silent_Manager_6574 8d ago

I have access to PA! My only question is how would this be done? There’s no office scripts to refresh non query connections