Refresh button for worksheets

B

Backsurge

New Member
Joined
Apr 5, 2011
Messages
5
Hi I want to be able to refresh a worksheet that is pulling in dde links from an external server. Is there any way I can refresh a worksheet instead of reopening it. Please help, Thank you.
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Sort by date Sort by votes
Not sure if this is the answer, but try hitting F9 to recalculate, should force the sheet to pull in the latest data, I think?
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question Question
Refresh All Queries on a Button without Macros?
Replies
1
Views
174
ExcelToDAX
E
Yecart77
  • Question Question
VBA Code to Refresh power Query Table unlock/lock worksheet
Replies
2
Views
499
Yecart77
Yecart77
R
  • Question Question
I need a vbscript to reopen a spreadsheet when it closes and refresh the document every minute.
Replies
7
Views
209
6StringJazzer
6StringJazzer
P
  • Question Question
Formulas disappear after data refresh (self referencing table)
Replies
1
Views
172
jkpieterse
jkpieterse
R
  • Solved
VBA Queries refresh and Save data as TXT
Replies
2
Views
262
Artik
Artik

Forum statistics

Threads
1,224,521
Messages
6,179,291
Members
452,902
Latest member
Knuddeluff

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top