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

#Excel alternatives for data analysis
#generative AI for data analysis
#row zero
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#rows.com
#google sheets
#VSTACK
#unique identifier
#Excel for the Web