Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Excel 2010 workbook that is shared by other users who periodically update various cells. Is there a shortcut key, like F5 with most web browsers, that updates the document with any changes that have been made since I opened the workbook?

The following do not work:

  • F5
  • F9
  • SHFT + F9
  • CTRL + ALT + F9
  • CTRL + ALT + SHFT F9
share|improve this question

Create an macro

Sub Makro1()
End Sub

Assing keyboard shortcut to the macro

share|improve this answer
Thanks, I will try that and update on effectiveness – Chipsgoumerde Apr 19 '13 at 16:05

Hitting Save works, as long as you are careful not to save anything you didn't want.

It's definitely odd that f5 doesn't refresh in Excel.

share|improve this answer
I would love to have a way to do it not involving saving, honestly. – Joshua Nurczyk Dec 7 '12 at 15:20

try ctrl+alt+F5

or go to data - connections - refresh all - refresh all

share|improve this answer
ctrl+alt+f5 does not work – kevin Apr 3 '12 at 15:42
data > connections has no connections and Refresh is greyed out – kevin Apr 3 '12 at 15:55
That refreshes data sources, not the document itself. – SilverbackNet Jan 3 '15 at 1:24

Alt + A, R, R or A in sequence will refresh the data.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.