Excel User Voice and Workbook Calculate

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:

  1. The Excel Dev Team actually read your suggestions on User Voice!
  2. 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!

This entry was posted in Calculation and tagged , , . Bookmark the permalink.

4 Responses to Excel User Voice and Workbook Calculate

  1. Nice idea! Already voted for it
    anyway, I also posted another one which is performance related which you might like
    Pasting conditional formats into standard formatting, like pasting values calculated by formula.
    I work with hidden rows where I store formats and formulas and use them to set formatting and refresh values. It works like a charm in big spreadsheets. I whish I had a way to do away with the ressources-hungry conditional formatting (but keep the ability to format depending on value). I even have a macro to set formating only on the row that is being changed, so the user hardly feels any difference with a regular spreadsheet — or so.


  2. Mike Benstead says:

    I agree. When two workbooks are open A larger one slows down a smaller one.

    Add to that I’d like to have a smaller DIARY.xlsm workbook on Autocalc and my larger TODO.xlsm on manual calc. At the moment you get one or the other.

  3. yury says:

    Voted! Great Idea. Originally I thought about Range.Calculate availability but your idea is better! Well done

  4. Jim says:

    3 Votes from me! I

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s