2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?😅

submitted by /u/Surge_x
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com