My excel file have about 52 sheets in it & its size is approximately 3 GB. How to split it into 52 different files based on the number of sheets and without opening the file? Because opening would consume a few hours to open, so it's very time consuming very not effective. Thank you.
You may want to use Power Query (or better still open the file in Excel and first clean up so that the size goes down). Here is one video on PQ ruclips.net/video/PiFAa_jjaEI/видео.html
Nice one Chandoo! An interesting challenge and fun learning project. Thanks for sharing this :)) Thumbs up!!
more than great Chandoo ♥
Please share macro code at the end of video
My excel file have about 52 sheets in it & its size is approximately 3 GB. How to split it into 52 different files based on the number of sheets and without opening the file? Because opening would consume a few hours to open, so it's very time consuming very not effective. Thank you.
You may want to use Power Query (or better still open the file in Excel and first clean up so that the size goes down). Here is one video on PQ ruclips.net/video/PiFAa_jjaEI/видео.html
Very useful, but little hard for beginners)
Thanks
Great