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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .