941 votes787 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!
768 votes124 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
I started using data validation, no macros or VBA. First construct your table like usual along with the formulas you need. Then select the top formulated cell of that row and go to data validation, select the correct "value" (in my case "whole number", even tho it's currency it still works) then enter the same formula you created in that cell in both the minimum and max bar. Be sure to include absolute references where needed. Important; uncheck "ignore blank" before you hit okay. Then press okay.
Copy this cell down to the end of the worksheet since data validation does not expand with the tables.
Hope this helps. In my case it works seamlessly and I don't need to protect that sheet since you can't enter any value in formulated cells other than the calculated value.