Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
share|improve this question
add comment

3 Answers

Create an macro

Sub Makro1()
ActiveWorkbook.RefreshAll
End Sub

Assing keyboard shortcut to the macro

share|improve this answer
    
Thanks, I will try that and update on effectiveness –  Chipsgoumerde Apr 19 '13 at 16:05
add comment

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.

share|improve this answer
    
I would love to have a way to do it not involving saving, honestly. –  Joshua Nurczyk Dec 7 '12 at 15:20
add comment

try ctrl+alt+F5

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

share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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