9

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

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. – Joshua Nurczyk Dec 7 '12 at 15:20
5

Create a macro

Sub Makro1()
ActiveWorkbook.RefreshAll
End Sub

Assing keyboard shortcut to the macro

1

try ctrl+alt+F5

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

  • 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
  • 1
    That refreshes data sources, not the document itself. – SilverbackNet Jan 3 '15 at 1:24
1

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

-1

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 '18 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.