Is it possible to delay VSTACK recalculation?
Using Excel for the Web: I have 4 tables, separated on 4 sheets, in a multi-author workbook, that are used for data entry. Each "entry" is comprised of 6 required cells in a row. Upon completion of a row, each entry is automatically assigned a unique identifier.
These tables are all compiled, using VSTACK, into a separate master sheet. The VSTACK utilizes a FILTER function, so it only compiles entries that have the associated unique identifier.
PROBLEM: My workbook experiences a significant calculation delay after each and every individual cell is entered (not the full row/entry).
It seems that VSTACK reevaluates data after each cell is entered, even when the unique identifier is not yet assigned. Is there a way to delay VSTACK from recalculating until a unique identifier is actually assigned (i.e. until 6 cells of a row are filled)?
Note: PQ is not an option.
Edit: thinking a bit outside the box here - Would it be possible to run a count on all assigned unique identifiers across all tables, then condition the primary VSTACK to =STFU() until that count changes?😅
[link] [comments]
Want to read more?
Check out the full article on the original site