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

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.