I wanted to ask a quick question that I’ve been struggling to figure out on my own — and I know there are a lot of helpful people here who might have ideas.
I receive a few Excel sheets each week via scheduled email exports. The issue I’m running into is that I’d like the parent rows to always be collapsed by default when the Excel file is sent out. Right now, the sheets open in whatever state they were last saved in, which varies since multiple people view and save the file.
I know I could create a separate sheet and use INDEX/MATCH to pull in the data, then send that version out — but I’d prefer to keep all the detailed information from the child rows included.
Does anyone know a way to make sure the parent rows will be collapsed when the file is sent?
