Excel User Voice
At the recent Excel Global Summit the Excel team were keen to explain how they have started using Excel User Voice to ask for and prioritise product improvement suggestions.
There are 2 important things to note about this:
- The Excel Dev Team actually read your suggestions on User Voice!
- Starting with Excel 2016 the development and ship cycle is much much faster than the traditional 3 years.
So it really is worthwhile making your suggestions to improve the product.
You get 10 votes on suggestions, and the suggestions are categorised by end-point and product area. So if you want to make a performance suggestion for Excel on Android phones you can focus down, see what other suggestions have been made in this area, and either cast a vote for an existing suggestion or make a new suggestion.
Workbook Calculate
To try this out I made a suggestion (about calculation of course).
At the moment from the UI you can either calculate all open workbooks (F9 or Automatic) or a worksheet (Shift F9).
From VBA you can also calculate a range (Range.Calculate and Range.CalculateRowMajorOrder).
But you cannot calculate a single workbook.
This is really annoying when you have 2 versions of a large slow workbook open, or you have a small rapidly changing workbook open that links to a large mostly static workbook.
My suggestion is to add an additional calculation setting: Calculate Active Workbook Only and from VBA Workbook.Calculate.
So please vote for my suggestion if you think it’s a good idea!