Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2023, 02:01 PM
kilroyscarnival kilroyscarnival is offline Looking for good Windows folder utility Windows 10 Looking for good Windows folder utility Office 2021
Expert
Looking for good Windows folder utility
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default Looking for good Windows folder utility

I went looking for the largest files on our almost-full shared drive, and found a few that could be moved, but I'm finding that one of the biggest issues is people saving a giant trove of full-size iPhone pictures. One person had transferred them zipped, then unzipped them, and they were taking up gigs and gigs of space 4-7MB at a time. I've been going through and finding these and bulk-resizing the photos, which we do want to keep, but not at original resolution.



I wish File Explorer could give me a list of the individual subfolders with the largest total size, so they could be inspected for zipping or reducing file size. I remember our former IT consultant mentioned a utility to me. I thought it was TreeSize Free, but it turns out that will only work on local drives, not on our server.
Reply With Quote
  #2  
Old 11-01-2023, 06:00 AM
kilroyscarnival kilroyscarnival is offline Looking for good Windows folder utility Windows 10 Looking for good Windows folder utility Office 2021
Expert
Looking for good Windows folder utility
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Just to update this: I had WizTree and some other stuff recommended, but decided to just do an Excel PowerQuery, with file sizes, then did a Pivot Table by folder path. This has the benefit of being updatable, and also I could then filter to include or exclude the types of materials I could, or couldn't, compress or reduce. I can use the same setup later to look for old Adobe PDF's which haven't been reduced in size.
Reply With Quote
  #3  
Old 12-08-2023, 09:49 AM
knight17 knight17 is offline Looking for good Windows folder utility Windows 10 Looking for good Windows folder utility Office 2021
Novice
 
Join Date: Dec 2023
Posts: 1
knight17 is on a distinguished road
Default

Winddirstat (open source) will do what you are looking for. You can analyze drives or specific folders and it will show you how the space is used.
Reply With Quote
  #4  
Old 12-11-2023, 06:34 AM
kilroyscarnival kilroyscarnival is offline Looking for good Windows folder utility Windows 10 Looking for good Windows folder utility Office 2021
Expert
Looking for good Windows folder utility
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by knight17 View Post
Winddirstat (open source) will do what you are looking for. You can analyze drives or specific folders and it will show you how the space is used.
Thanks, this had been recommended to me by our IT guy, but while it told me folder size, it didn't allow me to filter as I ultimately wanted to. For example:

Folder size for all subfolders containing "Photos" in the folder name, with contents from at least two years ago. Power Query gave me results I could filter to get this.

For other purposes windirstat would absolutely have done the job. They at least identify where the bigger stuff is. But with PQ I could further drill to stuff I could actually do anything about. One of my projects is taking caches of old photos and batch-reducing the file sizes of said photos. It's good busywork between other things.
Reply With Quote
  #5  
Old 12-11-2023, 07:18 AM
zpy2 zpy2 is offline Looking for good Windows folder utility Windows 10 Looking for good Windows folder utility Office 2013
Novice
 
Join Date: Sep 2023
Location: China
Posts: 28
zpy2 is on a distinguished road
Default

Re:Power Query gave me results I could filter to get this.
Do you want to get list of full path and size of each files?

didn't allow me to filter as I ultimately wanted to

What kind of filter?
Can you share some data and expected result?
Reply With Quote
  #6  
Old 12-11-2023, 07:23 AM
zpy2 zpy2 is offline Looking for good Windows folder utility Windows 10 Looking for good Windows folder utility Office 2013
Novice
 
Join Date: Sep 2023
Location: China
Posts: 28
zpy2 is on a distinguished road
Default

it turns out that will only work on local drives, not on our server.

server?
web server?
Reply With Quote
  #7  
Old 12-11-2023, 07:29 AM
kilroyscarnival kilroyscarnival is offline Looking for good Windows folder utility Windows 10 Looking for good Windows folder utility Office 2021
Expert
Looking for good Windows folder utility
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Sorry if I didn't say this: I'm good with what I have in PowerQuery now. Among other things, it gives me the ability to track what I've done.

Marking this thread as solved.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows Folder not accepting file change boatbody Windows 1 07-30-2019 06:46 AM
Looking for good Windows folder utility Entire Windows folder has disappeared! joewoods Windows 1 11-11-2016 08:58 PM
Looking for good Windows folder utility Outlook VBA to open a windows folder AndyDDUK Outlook 3 11-03-2015 02:07 AM
Looking for good Windows folder utility Autocorrect Utility aniljain44 Word 2 03-01-2011 07:33 AM
pst Merge Utility markg2 Outlook 2 12-27-2010 06:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft