1,206 votes193 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!
Lead Program Manager
An error occurred while saving the commentLisa commented
Just ran into this brick wall. Microsoft pitches using tables and structured references and then gives no way to lock the formulas down in an expandable table except data validation (slows things down so much it takes a few seconds to add a row) or VBA. If Microsoft wants large organizations to work their way up to power BI, it'd be a lot easier if I could demonstrate with tools mgt already has confidence in (e.g. tables, spreadsheets, etc.)Lisa supported this idea ·