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

5 Answers 5


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.

  • I would love to have a way to do it not involving saving, honestly. Dec 7, 2012 at 15:20

Create a macro

Sub Makro1()
End Sub

Assing keyboard shortcut to the macro


try ctrl+alt+F5

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

  • ctrl+alt+f5 does not work
    – kevin
    Apr 3, 2012 at 15:42
  • data > connections has no connections and Refresh is greyed out
    – kevin
    Apr 3, 2012 at 15:55
  • 1
    That refreshes data sources, not the document itself. Jan 3, 2015 at 1:24

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


Use Review, Track Changes, check Track changes while editing, and select the options you want.

  • 2
    The OP was asking how to refresh data. I don't remember using a shared spreadsheet that also had data to refresh, but I suppose you could unshare, refresh, then re-share(?).
    – thpope
    Nov 30, 2018 at 16:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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