10

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
Improve this question

5 Answers 5

Reset to default
6

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.

Improve this answer
1
  • I would love to have a way to do it not involving saving, honestly.
    – Joshua Nurczyk
    Dec 7, 2012 at 15:20
5

Create a macro

Sub Makro1()
ActiveWorkbook.RefreshAll
End Sub

Assing keyboard shortcut to the macro

Improve this answer
0
1

try ctrl+alt+F5

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

Improve this answer
3
  • 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.
    – SilverbackNet
    Jan 3, 2015 at 1:24
1

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

Improve this answer
-1

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

Improve this answer
1
  • 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 .