CesarF
New Member
- Joined
- May 16, 2009
- Messages
- 22
I'm working with spreadsheets since supercalc era...
I'm used to rely in Excel to dynamically adjust my formulas after a query is refreshed.
Before, I just set my formulas to the beginning and the end of the empty query rows.
Then after I refresh my query, all formulas (subtotals, ranges, etc...) were automatically adjusted accordingly the new query rows.
It had been working like a charm for decades.
It worked because they used 2 rows, even if query returned 0 or 1 data rows.
Recently, I think at least in 365 & 2019, a "genius" decided to "fix" it.
Now it's returning 1 row instead 2.
Suddenly all formulas relying on the query range are messed up after an empty query or with just 1 data row
Now I've do THEIR work, and manually adjust EVERY formula and RANGE with VBA.
Now I've hundreds of issues, and a lot of angry customers.
Do you know a workaround?
Do you know who's the genius?
Can you tell them to FIX it or at least guide me to a page to report their error?
br,
Cesar.
I'm used to rely in Excel to dynamically adjust my formulas after a query is refreshed.
Before, I just set my formulas to the beginning and the end of the empty query rows.
Then after I refresh my query, all formulas (subtotals, ranges, etc...) were automatically adjusted accordingly the new query rows.
It had been working like a charm for decades.
It worked because they used 2 rows, even if query returned 0 or 1 data rows.
Recently, I think at least in 365 & 2019, a "genius" decided to "fix" it.
Now it's returning 1 row instead 2.
Suddenly all formulas relying on the query range are messed up after an empty query or with just 1 data row
Now I've do THEIR work, and manually adjust EVERY formula and RANGE with VBA.
Now I've hundreds of issues, and a lot of angry customers.
Do you know a workaround?
Do you know who's the genius?
Can you tell them to FIX it or at least guide me to a page to report their error?
br,
Cesar.